Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sp_configure 'allow updates', 1
- go
- reconfigure with override
- GO
- update sysdatabases set status = 32768 where name = 'TestDB'
- go
- sp_configure 'allow updates', 0
- go
- reconfigure with override
- GO
- DBCC REBUILD_LOG(TestDB,'D:SQL_LogTestDB_Log.LDF')
- exec sp_resetstatus TestDB
Add Comment
Please, Sign In to add comment