Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to open standby database for read/write?

  
   Database Help (Home) -> Server RSS
Next:  [newbie] Schema Relation in SQL  
Author Message
Lena

External


Since: Jun 04, 2008
Posts: 4



(Msg. 1) Posted: Tue Jul 19, 2011 11:35 am
Post subject: How to open standby database for read/write?
Archived from groups: microsoft>public>sqlserver>server (more info?)
Hello!
I have log shipping setup between primary sql server and standby
server. Both servers are MSSQL 2005 Enterprise.
What are the steps to open standby for read/write (I need it to make
primary at one point as a migration step)?

Thanks,
Lena

 >> Stay informed about: How to open standby database for read/write? 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 2061



(Msg. 2) Posted: Tue Jul 19, 2011 5:25 pm
Post subject: Re: How to open standby database for read/write? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Lena ( ) writes:
> I have log shipping setup between primary sql server and standby
> server. Both servers are MSSQL 2005 Enterprise.
> What are the steps to open standby for read/write (I need it to make
> primary at one point as a migration step)?

I have not actually tested this, but I would expect that the command is

RESTORE DATABASE db WITH RECOVERY


--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

 >> Stay informed about: How to open standby database for read/write? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
sql read and write in 64K? - Does SQL read and write in 64K blocks ? Reason I ask is with regards to formatting our partition.

Using sql script to select users with read or write access.. - Is this possible? I am trying to select users/logins in a SQL Server 2000 database with read permissions or write permissions via writng sql script I want to use asp to restrict functionality based on read write database access to only certain users..

"Attempted to read or write protected memory" when opening.. - Whenever I select the "New Query" option or attempt to open any saved query in SQL Server Management Studio, I get the following error: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. ...

write SP before target database is created - I think there is an option that will allow you to write a stored procedure that loads data on a server that is not yet created (server created but not the database). This would be for used for transfering data from one existing object to another not...

Recover a standby db - Hi, I have a standby server with standby db sync-ed with prod through log shipping. I have all log files crashed(backup server). No log files. I need to recover the db in standby server without any log files. How do I do it? Thanks
   Database Help (Home) -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]