InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 08:48:39 GMT20http://www.sqlservercentral.com/Forums/Topic1401850-1550-1.aspxThe SQL agent logs nor the SQL Server logs show any errors.Fri, 04 Jan 2013 09:04:49 GMTxanthoshttp://www.sqlservercentral.com/Forums/Topic1401850-1550-1.aspxFor 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 AdminError 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_fileswhere 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 timeHas anyone seen this kind of behaviour? And do you know what causes it and how to prevend it?CheersWed, 02 Jan 2013 07:46:21 GMTxanthos