Backups to a Share Drive

Question

Backups to a Share Drive

Welsh Corgi

SSC Guru

Points: 116520
More actions
February 10, 2013 at 5:22 pm

#273945

I execute the Job and it succeeds. However I go to the location that I specified as the backup location and there is no backup in that share.
What do I need to do?
Thanks.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281344 More actions · Answer 1

Any jobs deleting it or moving it after it completes?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

SQLRNNR (2/10/2013)
Any jobs deleting it or moving it after it completes?

Thanks for responding.

There are no jobs that delete the backups. I installed this server from scratch.

The backup file is not there.

Thanks again.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR SSC Guru Points: 281344 More actions · Answer 3

Can you provide the backup command being issued?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

SQLRNNR (2/10/2013)
Can you provide the backup command being issued?

Yes Sir.

EXECUTE master.dbo.xp_create_subdir N'E:\Backups\Differential\MyDB'
GO
BACKUP DATABASE [MyDB] TO DISK = N'E:\Backups\Differential\MyDB\MyDB_backup_2013_02_10_205300_1612807.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'MyDB_backup_2013_02_10_205300_1202766', SKIP, REWIND, NOUNLOAD, STATS = 10

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR SSC Guru Points: 281344 More actions · Answer 5

Silly question, but you have a full backup in place right?

When the backup is running, have you tried watching the folder (in progress) to see if the file even starts to create?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

I am assuming that E is a mapped drive to a shared network resource?

VastSQL SSC-Dedicated Points: 36278 More actions · Answer 7

Instead of giving Drive letter ie E in this case give the network path name ie \\servername\E$\path

Hope this helps