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 |
|
jhunu
Starting Member
18 Posts |
 Posted - 2011-11-22 : 14:01:26
|
| I want to move the MDF and LDF file from C: to d: .Its not allowing me to move . How to solve this issue |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jhunu
Starting Member
18 Posts |
Posted - 2011-11-22 : 14:18:26
|
| Thanks for the help. I am using Detach and attach method for moving . |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jhunu
Starting Member
18 Posts |
|
|
jhunu
Starting Member
18 Posts |
Posted - 2011-11-22 : 14:43:35
|
| Msg 947, Level 16, State 1, Line 1Error while closing database 'Cardv32'. Check for previous additional errors and retry the operation. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-11-22 : 14:51:31
|
| Googling your error seems to indicate your database might be corrupt. Verify if the detach worked or not. Even though it errored, it may have detached it anyway. If it did detach it, move your files to where you want them, and then try to attach it. If detach/attach doesn't work, you'll need to verify that your database is okay via DBCC CHECKDB. If it is okay, you can move your files around with BACKUP/RESTORE instead.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
MDF and LDF file from C: to d: .