Per Eng: You cannot use SQL Server VDI (or VSS) to backup a database in standby mode. I'm not quite sure what would happen, but you could probably use consistent split, non-vdi and attach the database to the SQL Server instance running on the reporting server.
I have created for testing purpose one MS SQL database which is placed in read-only mode. I have succesfuly created replica of that DB, and mounted it to alternate host. Database was succesfuly attached in SQL. As I know, DB which is created using logshipping is also in read-only mode, so I can not see what can be a problem.
Sirius31
22 Posts
0
February 25th, 2008 05:00
You cannot use SQL Server VDI (or VSS) to backup a database in standby mode. I'm not quite sure what would happen, but you could probably use consistent split, non-vdi and attach the database to the SQL Server instance running on the reporting server.
mladjos
4 Posts
0
February 25th, 2008 08:00
I have created for testing purpose one MS SQL database which is placed in read-only mode. I have succesfuly created replica of that DB, and mounted it to alternate host. Database was succesfuly attached in SQL. As I know, DB which is created using logshipping is also in read-only mode, so I can not see what can be a problem.
Message was edited by:
Mladen Krivokuca