Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Snapshots Fail Expand / Collapse
Author
Message
Posted Wednesday, January 2, 2013 7:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 8, 2014 7:23 AM
Points: 298, Visits: 654
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
Post #1401850
Posted Friday, January 4, 2013 9:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 8, 2014 7:23 AM
Points: 298, Visits: 654
The SQL agent logs nor the SQL Server logs show any errors.
Post #1402944
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse