Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Create Snapshot for Databases with Multiple Data Files in sqlserver

Tags:

sql

sql-server

How to create database snapshot for databases which have primary data file (.mdf) and secondary data files (.ndf files) too. Throws exception Missing the file databaseName_EX when I create it.
The database file includes databaseName_EX.ndf and databaseName.mdf

CREATE DATABASE databaseName_report_snap ON
(Name ='databaseNameJ',
FileName='E:\SqlData\databaseName_report.snp')
AS SNAPSHOT OF databaseName;    
like image 613
ontashkal Avatar asked Nov 15 '25 22:11

ontashkal


1 Answers

CREATE DATABASE databaseName_report_snap ON
(Name ='databaseName',
FileName='E:\SqlData\databaseName_report.snp'),
(Name ='databaseName_EX',
FileName='E:\SqlData\databaseName_report_ext.snp')
AS SNAPSHOT OF databaseName;    
like image 192
ontashkal Avatar answered Nov 17 '25 18:11

ontashkal