For reporting and ETL purposes we recreate snapshots on a 30 minutes schedule.
Every now and then snapshots fail to be created. The following query:
CREATE DATABASE Admin_SnapShot ON
(Name = [Admin], FILENAME ='E:\SQLData\Admin_SnapShot.ss')
AS SNAPSHOT OF Admin
Error with Msg 5014:
The file 'Admin' does not exist in database 'Admin'.
The logical file name Admin is correct as the following:
select name , type_desc, physical_name from sys.master_files
where database_id = db_id('Admin')
Shows 'Admin' as the name for the mdf.
Restarting the SQL service normally causes the creation of snapshots to be created succesfully. Other times snapshots get recreating over time
Has anyone seen this kind of behaviour? And do you know what causes it and how to prevend it?