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;
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;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With