Database Backup By using UNC path

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Database Backup By using UNC path

Author

Topic

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-01-12 : 01:24:33

While trying taking full backup, simply on UNC path with following statement
BACKUP DATABASE [DB_NAME]
TO DISK = N'\\BACKUPSERVER\DBBACKUPS\test_UNC.BAK'

getting following error:

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\BACKUPSERVER\DBBACKUPS\test_UNC.BAK'. Operating system error 53(The network path was not found.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

WHAT I M MISSING ???

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-12 : 01:26:55

Login with the SQL Server service account and verify if it can get to this:

\\BACKUPSERVER\DBBACKUPS

Do you get an error with the SQL Server service account?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-01-12 : 01:44:13

Thanx Tara, it worked

I restarted my sql services with domain account and it worked

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-12 : 08:19:18

Read this:
http://support.microsoft.com/kb/207187

rooparaj.k.n
Starting Member

1 Post

Posted - 2009-02-27 : 01:23:01

quote:
Originally posted by lionofdezert

Thanx Tara, it worked

I restarted my sql services with domain account and it worked

how do i give domain account to sql services .

subhash chandra
Starting Member

40 Posts

Posted - 2009-02-27 : 02:14:43

In SQL Server Configuration Manager open the properties of SQL Server instance then in "Log on" tab provide the account details in "This account" section.
Restart the SQL server service.

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2009-02-27 : 13:47:54

quote:
Originally posted by rooparaj.k.n

quote:
Originally posted by lionofdezert

Thanx Tara, it worked

I restarted my sql services with domain account and it worked

how do i give domain account to sql services .

you can also do this through service control manager..services.msc
select the sql server instance -> properties..and explore...

Regards,
Ahmad Osama

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources