Microsoft SQL Server:Resize Database Transaction Log by Detach/Atta



Use Detach/Attach method to re size/re create Transaction Log.

1.Detach Database.



 

2.Rename old Transaction log.




3.Attach Database.

 

4.Remove transaction log to attach.

 
 5.Click Ok to Attach.It will create MODEL Database Sized Transaction Log.


Comments

Post a Comment

Dear User,

Thank you very much for your kind response

Popular posts from this blog

Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL

Image
Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL  APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and later Information in this document applies to any platform. GOAL  How to purge the  UNIFIED_AUDIT_TRAIL table ? SOLUTION The unified audit trail can be purged using the DBMS_AUDIT_MGMT package:  qlplus / as sysdba SQL>  select  count(*) from unified_audit_trail;   COUNT(*) ----------       2619 SQL>  BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL( audit_trail_type         =>  DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp  =>  FALSE); END; / PL/SQL procedure successfully completed. SQL>  select  count(*) from unified_audit_trail;   COUNT(*) ----------          1 You can also use the last_arch_timestamp, if you don't want to purge all ...
Read more

Oracle 11g:Upgrade 11.2.0.x version to latest 11.2.0.4.1 patchset:Upgrade

Image
Oracle 11g:Upgrade 11.2.0.x version  to latest 11.2.0.4.1 patchset:Upgrade  Once We finish the installation of 11.2.0.4 on different then we will go further for upgrade database. For Installation, http://oracle-mssql-dba.blogspot.in/2014/07/oracle-11gupgrade-1120x-version-to.html Step 2.Run Pre-upgrade Information Tool  SQL>spool /utlu112i.log SQL>@ORACLE_HOME/rdbms/admin/utlu112i.sql Check timezone .Need to upgrade if it is require by tool. Step 3.Run dbupgdiag.sql.Check any invalid objects in dba_registry. Valid all Dba_registry object by running utlrp.sql sql>sqlplus / as sysdba sql>@?/rdbms/admin/utlrp.sql Step 4.Backup database. a)take rman backup with latest spfile & controlfile. b)take cold backup by mount the database after shutdown normal db. Step 5.Shut down database normal. SQL>shutdown normal. Step 6.Set New Oracle_HOME,PATH,LIBRARY_PATH.Copy tnsnames.ora,listener.ora,spfile,pfile & password to n...
Read more

Oracle 10gR2:Reconfigure Data Control by EMCA

Image
1.Set oracle parameter Set oracle_sid=blogdb Set Oracle_Home=F:\oracle\product\10.2.0\db_1 2.De configure and delete old entries. emca -deconfig all db -repos drop 3.Configure Data Control. emca -config all db -repos create Output May 22, 2012 12:07:44 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at F:\oracle\product\10.2.0\db_1\cfgtoollog s\emca\blogdb\emca_2012-05-22_12-06-05-PM.log. May 22, 2012 12:07:47 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... May 22, 2012 12:07:47 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository May 22, 2012 12:07:47 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at F:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\bl ogdb\emca_repos_create_<date>.log for more details. May 22, 2012 12:07:47 PM oracle.sysman.emcp.EMConfig perform SEVERE: Error creating the repository ...
Read more