Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sajmeister
Starting Member
1 Post |
 Posted - 2009-06-30 : 08:28:34
|
| Hi guys,I have some trouble taking a SQL 05 DB offline where I can then detach it and remove the .ldf file and reattach it so a new smaller .ldf file gets created. Current .ldf file is 10GB!SQL just takes ages taking the db offline, get the 1 minute remaining window, then get an error logged 18456, severity 14 and state 16. I have tried this using the SA credential.Any help much appreciated.ThanksSajmeister |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-06-30 : 12:06:53
|
| I don't agree with detaching and drop the log file, especially if this is production. It can/will lead to corruption of your database. Having said that, you error can be researched at:http://www.lmgtfy.com/?q=error+18456Terry-- Procrastinate now! |
 |
|
|
|
|
|
Taking DB offline takes ages