I'm using SQL Server 2005. I've created a snapshot of database (RM_DB), I want to create (RM_DB_NEW) from that snapshot. The only option i get when I right-click on my snapshot is "Restore [RM_DB] from this snapshot".
我正在使用SQL Server 2005.我已经创建了数据库快照(RM_DB),我想从该快照创建(RM_DB_NEW)。我右键单击快照时唯一的选择是“从此快照恢复[RM_DB]”。
Can I create a NEW database from my snapshot?
我可以从快照创建一个新数据库吗?
EDIT
I'm not interested in creating a backup out of the snapshot, this would undermine the whole point. I can back my DB up any time, and restore any other db from it. I'm interested in the ability of doing it all DIRECTLY FROM A SNAPSHOT
我对从快照创建备份不感兴趣,这会破坏整个点。我可以随时备份我的数据库,并从中恢复任何其他数据库。我对直接从快照中完成所有操作的能力感兴趣
3 个解决方案
#1
A snapshot is not the full set of data... it's basically only changed pages. It is incomplete without the source database.
快照不是完整的数据集......它基本上只是更改了页面。没有源数据库它是不完整的。
So, you can't create a database from a snapshot.
因此,您无法从快照创建数据库。
数据库快照的工作原理
Limitations and Requirements of Database Snapshots
数据库快照的限制和要求
#2
create a new database, restore from the snapshot onto the new db. you may have to go into the options tab and ensure "force overwrite" is checked.
创建一个新数据库,从快照恢复到新数据库。您可能必须进入选项选项卡并确保选中“强制覆盖”。
#3
Step 1. Create a backup (*.bk file) from your snapshot. Step 2. Restore RM_DB_NEW from the backup.
步骤1.从快照创建备份(* .bk文件)。步骤2.从备份中恢复RM_DB_NEW。
#1
A snapshot is not the full set of data... it's basically only changed pages. It is incomplete without the source database.
快照不是完整的数据集......它基本上只是更改了页面。没有源数据库它是不完整的。
So, you can't create a database from a snapshot.
因此,您无法从快照创建数据库。
数据库快照的工作原理
Limitations and Requirements of Database Snapshots
数据库快照的限制和要求
#2
create a new database, restore from the snapshot onto the new db. you may have to go into the options tab and ensure "force overwrite" is checked.
创建一个新数据库,从快照恢复到新数据库。您可能必须进入选项选项卡并确保选中“强制覆盖”。
#3
Step 1. Create a backup (*.bk file) from your snapshot. Step 2. Restore RM_DB_NEW from the backup.
步骤1.从快照创建备份(* .bk文件)。步骤2.从备份中恢复RM_DB_NEW。