December 8, 2002 at 4:04 am
I want to take the back up of my database on other machine that is not running SQL server.
How do I do it?
December 8, 2002 at 6:44 am
BACKUP DATABASE [dbnamehere]
TO DISK = '\\server\share\path\filename.bkp'
WITH
(see options for Backup Database in SQL BOL)
Then beyond that you have to make sure the remote machine has proper rights on the share for the connection being made to access.
If however you just mean you need to perform the backup from another machine then install client tools so you can attach to the server or check out using VB to accss the server and either DMO (lots of info on this thru these threads on this site just search) or use ADO to connect and setup an SP on the remote server to be called that can make the backup.
December 8, 2002 at 7:14 am
The backup is always performed by the server itself. You can make a backup of the .ldf and .mdf files if you want a "sorta" backup from another machine.
if what you are asking is how to store your backups on another machine, you need to start SQL Server with a domain ID that has network access. What we do is backup the files locally and then replicate them to an archive machine and delete the local copy. It's faster to backup but slower to recover.
December 8, 2002 at 7:43 am
Another thought, if your database is very large keep in mind the backup will be fairly large too. If this is a concern and a factor in why you wish to push to another machine you might want to check out SQLZip or SQLLiteSpeed as they do file compression on the backups which can save space, network resources and time. Especially if you do the backups locally as Don suggest and move afterwards.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply