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 |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2006-10-17 : 09:29:01
|
| Hi Experts!I am trying to restore a database backup of SQL 2005 database.But when ever it is restored, it is in readonly mode. Why is this so?Below is the command I am executing.restore database MYDB From disk ='D:\MYDB.bak' WITH RECOVERY, REPLACE, MOVE 'MYDB_Data' TO 'C:\MYDB_Data.mdf', MOVE 'MYDB_Log' TO 'D:\MYDB_Log.ldf' GO Thanks in advanceRegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-10-17 : 09:47:47
|
| Most likely it was in read only when you took the backup.Just change it to read-write.-------Moo. :) |
 |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2006-10-17 : 12:12:18
|
| Thanks Mist,I think you are correct. I did a test and you are abslty correct.RegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
|
|
|
Restore 2005 Database Backup