Remot_Backup

Hot Topic

sp_send_dbmail & COM errors.
DHCP Service fails to start after installing SQL Server 2005 April CTP
does the XML Task update XML files?
Best Practice for retrieving last record
Receving error with no description
Transition from Crystal Reports
Access chart Palette color set in custom code
Deployment 'utility' script using sqlcmd
SQL Server CE 2.0 to SQL Server 2005 Express
Scheduling SSIS Package

SQL Server

sql server management studio nov ctp
Loading a column by name (via Variable, etc.)
How to upload rdl programmatically
Why is sort so slow?
Remote synchronise from PDA to SQL Server 2005
SP with SSIS and 2005 database
SSIS installable for sql server express
Error when attempting to delete rows
HELP!!:about the MS association rules
error '800a03eb' Type mismatch

Remot_Backup

How can i take a backup of remote sql server and that .bak file will save on my local system is there any T-sql code for it

Answer this question

Remot_Backup

philipa
Connect and login to the remote SQL Server, and run:

backup database myDb to disk = 'pathToMyLocalDisk\myDb.BAK'

-- edit
This assumes that the remote SQL Server is able to reach your local disk over the network, and also have permissions to write there, however.

/Kenneth
Shirajul Alam
No, backup and restore information is always grabbed from the server. (So, e.g. C:\somebackup.bak is always server located) So if your server doesn’t have access to your client and therefore can use an UNC path to directly backup the database to your client, you can’t do it.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
Remot_Backup

Answer this question