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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to convert read only to read write database

Author  Topic 

Holydon
Starting Member

8 Posts

Posted - 2008-10-06 : 10:12:56
Please, a restore was made on my database and it turned to standy/read only...making it difficult for me to backup or do restore.what I only see is atransaction log......moreover. I see a bak file in the mssql directory called rollback_undo_mydbname which is 40k....please how do I make it read write, for future backups and restoration

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-06 : 10:35:31
Can you explain clearly? Didn't get it?
Go to Top of Page

lamujerdetuhermano10
Yak Posting Veteran

75 Posts

Posted - 2008-10-06 : 16:20:05
this is a security issue
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-06 : 16:22:36
Holy cow!
Holydon is your fifth sixth alias here at SQLTeam?


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -