Unsolved
This post is more than 5 years old
4 Posts
0
318
February 25th, 2008 05:00
Create replica from SQL logshipping database
Hi all,
Is it possible to create snapshot replica of logshipping database which is refreshed every 15 minutes from original database? We will use Replication Manager to create snapshot and to mount those replicas to alternate server.
Is it possible to create snapshot replica of logshipping database which is refreshed every 15 minutes from original database? We will use Replication Manager to create snapshot and to mount those replicas to alternate server.
0 events found
No Events found!
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