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