Backup using Network drive - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Backup using Network drive

Author

Topic

logie0726
Starting Member

17 Posts

Posted - 2009-08-06 : 03:09:49

Anyone here can help me backup using a Network Drive. Previously I can manage to run this script but after I Reformat the server it wont work. This is the script.

BACKUP DATABASE [MYDB] TO  DISK = N'\\payroll\MYDB Backup\MYDB_backup.bak' WITH  INIT ,  NOUNLOAD ,  NAME = N'ECSSTARDBA backup',  NOSKIP ,  STATS = 10,  NOFORMAT

But I can access that path using the server and I can see the files on MYDB Backup Folder.

But stil I'am getting the error

Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\payroll\MYDB Backup\MYDB Backup.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

dschutz
Starting Member

5 Posts

Posted - 2009-08-06 : 13:02:57

I've seen similar to this before. Sometimes the backup file becomes corrupted and will not let you overwrite or append it. If you already have a copy of MYDB_backup.bak on the network drive, remove it. Then try your backup.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-06 : 14:56:48

check sql server service account has permissions on \\payroll\MYDB Backup\

rajendermakhija
Starting Member

2 Posts

Posted - 2009-08-07 : 00:16:08

Run your SQL Server Services with user who have rights on this folder

logie0726
Starting Member

17 Posts

Posted - 2009-08-07 : 05:28:54

@russell : how can i check the sql server service account permission. where can i find that?

@rajendermakhija : I cannot find the SQL Server Sevices where is is located?

THANKS FOR YOUR REPLY...

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-07 : 14:25:09

rajendermakhija and I are saying basically the same thing.

go to administrative tools / services / mssqlserver

the account needs permissions on the share you're backing up to.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources