Snapshots Fail

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Snapshots Fail

Snapshots Fail

Rate Topic

Display Mode

Topic Options

Author

Message

xanthos

Posted Wednesday, January 02, 2013 7:46 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, May 03, 2013 9:09 AM
Points: 267, Visits: 622

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

xanthos

Posted Friday, January 04, 2013 9:04 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, May 03, 2013 9:09 AM
Points: 267, Visits: 622

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

Post #1402944

« Prev Topic | Next Topic »

Permissions