it is possible to take sql server2000 database backup on another machine''s disc.

Question

it is possible to take sql server2000 database backup on another machine''s disc.

Papillon

Hall of Fame

Points: 3303
More actions
July 25, 2005 at 2:40 am

#186708

Hello friends
Can anybody knows,it is possible to take sql server2000 database backup on another machine's disc.

I normally take backup on the disc of same machine where my database server is but if i want to take backup to another machine disc then that will possible???
T.I.A
Shashank
Regards,
Papillon

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 1

You can perform a backup to a UNC name, you just need to make sure that the account used for SQL has access to the remote machine.

Papillon Hall of Fame Points: 3303 More actions · Answer 2

Hello thanx

what my problem is we have 5 to 6 machine which are shared this server which is on my machin

but i want to take back up not on my machin but directly on machine number say like 3 normally what i m doing now is take backup on my machin and then transfer it to machine number 3 ...so i want solution for this

T.I.A

shashank

Regards,

Papillon

Kishore-132325 Hall of Fame Points: 3784 More actions · Answer 3

You can either create a Network Drive (mapped drive of some other machine on your machine) or a UNC path to that machine.

For example :

\\machinename\sharename

OR

Driveofnetworkmachine(F:\)\foldername

You need to make sure that you have administrative priviliges on the mapped network drive or the UNC path.

I have been using mapped network drive for my Full and Transaction Log backups for 5 years now. It has been working perfectly fine with me.

Do let me know of your progress.

--Kishore

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 4

You can also make the backups using SQL-devices.

So from within you sql-backup-job you can see zip , but your backup-device will point to an UNC-destination.

copied from BOL
USE master

EXEC sp_addumpdevice 'disk', 'MyDbFullbackup', '\\myserver.mydomain.domsuffix\sharename\path\filename.BAK'

go

BACKUP DATABASE [MyDb] TO [MyDbFullbackup] WITH INIT ,

NOUNLOAD , NAME = 'MyDb_Full',

SKIP , STATS = 10, DESCRIPTION = 'Full Database Backup' , NOFORMAT

go

This will need your sqlserver-serviceaccount to have permissions to write to \\myserver.mydomain.domsuffix\sharename\path\. (This can be no problem if you are allready copying in your current situation.)

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Paul Pennock Ten Centuries Points: 1091 More actions · Answer 5

Beware of networks when backing up\restoring from remote devices network connections can drop for any number of reasons and this can make these processes unstable