1) Rename the transaction log files. 2) Rebuild the master database. 3) Create a similar database. The new database does not have to be the same size; however, it must contain the same number of data and log files. 4) Stop SQL Server. 5) Delete all the data files of the newly created database so that it will fail recovery.
Replace the log files of the new database with the original log files so that you can backup the transaction log.
6) Restart SQL Server.
7) Run this command to back the tail of the log:Backup Log
8) Use the sp_dbremove stored procedure to remove the database.
No comments:
Post a Comment