Creating a Database Snapshot
One of the first things you must figure out before you create a database snapshot is whether your source database data portion has more than one physical file in its allocation. All of the data file references must be accounted for in the snapshot. To get a list of all of the data files for a database, you can run the following query within the source database:
use AdventureWorks2012goselect name, physical_name from sys.database_fileswhere type_desc = 'ROWS'go
The data file allocations for this database returned by this query are as follows:
name physical_name------------------------ ------------------------------------------AdventureWorks2012_Data C:\MSSQL\Data\AdventureWorks2012_Data.mdf ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
