Snapshots Fail

• xanthos

  SSCrazy

  Points: 2510

  More actions

  January 2, 2013 at 7:46 am

  #268160

  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?

  Cheers

• xanthos

  SSCrazy

  Points: 2510

  More actions

  January 4, 2013 at 9:04 am

  #1573808

  The SQL agent logs nor the SQL Server logs show any errors.