October 10, 2015 at 12:37 pm
Assuming we have enterprise edition on Server A and Server B, can i take snapshot of database A from Server A and have it restored on server B? I do know there are other ways but i am more interested to know if snapshot works in my case
October 12, 2015 at 2:46 am
No.
A snapshot is not a backup. It's just a collection of the original version of pages that have changed in its source database since the snapshot was created. It is not an entire database, it is tied to its source database and cannot be moved anywhere, cannot be backed up, cannot be detached and is meaningless without its source database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2015 at 9:22 am
i am fine if the queries from serverB are hitting the data files on server A. Can i even take a snapshot from one server to another server?
October 12, 2015 at 9:28 am
GilaMonster (10/12/2015)
it is tied to its source database and cannot be moved anywhere, cannot be backed up, cannot be detached and is meaningless without its source database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply