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

Lena (lenaglozman (AT) yahoo (DOT) com) writes:
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 (AT) sommarskog (DOT) 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