SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Backup on remote machine
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

yadhu_cse
Constraint Violating Yak Guru

India
252 Posts

Posted - 12/02/2010 :  07:03:56  Show Profile  Reply with Quote
Hi,
i want to store backup on remote machine. i crated a new folder and shared with full permission.
when i execute

BACKUP DATABASE test1 TO DISK = '\\machine name\data\backup.bak' WITH NOFORMAT, NOINIT, NAME = N'SAMPLE-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

i am getting following error
BACKUP DATABASE test1 TO DISK = '\\machine name\data\backup.bak' WITH NOFORMAT, NOINIT, NAME = N'SAMPLE-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

webfred
Flowing Fount of Yak Knowledge

Germany
8766 Posts

Posted - 12/02/2010 :  07:12:36  Show Profile  Visit webfred's Homepage  Reply with Quote
I guess that isn't the error message...


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

India
252 Posts

Posted - 12/02/2010 :  07:45:19  Show Profile  Reply with Quote

sorry i am getting following error
Cannot open backup device '\\tiger\data\backup.bak'. Operating system error 5(Access is denied.)
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8766 Posts

Posted - 12/02/2010 :  07:48:56  Show Profile  Visit webfred's Homepage  Reply with Quote
found this: http://support.microsoft.com/kb/207187/en-us

To enable backups to network drives, perform the following steps:
The SQL Server service must be started using a domain user account to access any resources on a remote computer. Verify that the MSSQLServer service is started under a domain account that has write access to both the Windows NT Server share and its underlying partition (if the partition is formatted with the Windows NT file system, or NTFS).
In Control Panel, double-click the Services icon.
Select the MSSQLServer service and then click Startup.
Examine the startup options for the service and verify that This Account is selected and that a valid domain account is supplied in the form Domain_Name\Domain_account (with the correct password).

NOTE: If you changed the service to run under a domain account, you must stop and restart the MSSQLServer service.
Verify that the account specified has write access on the Windows NT share to which you are backing up, as well as the underlying partition (if the partition is formatted as NTFS). To do this, perform the following steps:


Right-click the share name in Windows NT Explorer.
Click Sharing on the shortcut menu.
On the Security tab, click Permissions.



No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

India
252 Posts

Posted - 12/02/2010 :  07:53:05  Show Profile  Reply with Quote
I am nOt getting
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 12/02/2010 :  08:51:35  Show Profile  Visit russell's Homepage  Reply with Quote
Fred is telling you to make sure that the SQL Service account has permissions on the share -- which it doesn't according to your error message. The link he provided, as well as his explanation shows how to setup the permissions.
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

India
252 Posts

Posted - 12/02/2010 :  23:40:24  Show Profile  Reply with Quote
k. HOw to set permission to services.
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

India
252 Posts

Posted - 12/03/2010 :  00:40:29  Show Profile  Reply with Quote
Hi, Can u tel me the procedure to do it. service is running under local system account
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 12/03/2010 :  03:10:47  Show Profile  Reply with Quote
In my experience you would be much better of performing the backup to a Local drive and then Moving (i.e. MOVE not COPY) the file to the network location sparately.

If you make a backup direct to a network share and anything goes wrong with the network you have NO backup. If you do it locally then,. at worst, you may have a queue of files waiting to be MOVED to the network share.

RoboCopy (part of Windows 2008 Server, available to download for earlier versions) will do the MOVE for you (it is tolerant of network outage and will keep retrying until it gets the job done.
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

India
252 Posts

Posted - 12/05/2010 :  23:40:46  Show Profile  Reply with Quote
Hi,
I am using workgroup computer. how to performbackup on workgroup comp.that is storing on another computer
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000