June 6, 2003 at 7:49 am
Hi,
Bit of an odd one this, I have had a request to trigger a SQL database dump from a different server to the one that the db is on and to trigger the dump from a command line so that the db dump is synchronised to other backup tasks. Does anyone know what command needs to be executed?
Hope this makes sense
June 6, 2003 at 8:01 am
You could run the BACKUP DATABASE command in a sql script using ISQL with the -S option to specify the name of the server to run the script on.
June 13, 2003 at 12:28 pm
You could also encapsulate the dump in a dts, and use the dtsrun.exe utility that comes with SQL. Or, if you know scripting, SQL-DMO and SQL-NS give ultimate control of SQL Server
June 16, 2003 at 7:38 am
Hi all
Managed to crack it as follows
isql /U [SQL Login Name] /P [Password(Can be hidden)] /S [Server Name] /q "backup database [DB Name] to [Dump name]with init
Thanks for all the help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply