Wednesday, March 7, 2012

Backup on remote disk

hi gurus,

can any bdy tell me the procedure to create the Backup Device which is a DISK OF REMOTE PC..

i want to take database backup on remote pc's disk not on local disk or tape

i am using sql server 2005

thanks

in advance

I believe you want to backup your db to a remote pcs hard disk.....just perform the following,

1.ensure you run the the sql server using service account instead of local system account

2.ensure that your sql service account has modify privileges in the remote pcs shared folder......

http://msdn2.microsoft.com/en-us/library/ms179313.aspx

refer this command

USE master;
GO
EXEC sp_addumpdevice 'disk', 'networkdevice',
'\\<servername>\<sharename>\<path>\<filename>.bak'

http://msdn2.microsoft.com/en-us/library/ms188409.aspx fyi

just check if those links are useful......

thanks

|||

actually, you do not need to add a dump device, simply execute:

Code Snippet

backup database MyDB to disk = '\\Server\Share\BackupFilename.BAK'

No comments:

Post a Comment