[sims] Can You Use dbattach to Automate Database Backups on Another SQL Server?

[JRA]

Hello all - as per title, for "quick and dirty" backups of some SQL databases on another server, is it possible (or advisable, or even not) to copy dbattach.exe to another (non-SIMS) SQL server, and call it in a scheduled batch file to back up the databases on that?

 

Thanks in advance for any opinions, horror stories or otherwise.

[vikpaw]

No. Don't risk it.

Why would you want to? Use SQL Management Studio and have full control over the process.

 

dbattach is likely to be calling custom stored procedures to fiddle with logins, or worst case could be changing the mode of the DB.

[JRA]

Thanks Vikpaw! Okay, shan't do that then.

 

Trudging through the SQL walkthroughs for a batch file instead.

[JRA]

(If anyone else in the future finds this and is as clueless as I was for most of today, have a gander: https://www.outcoldman.com/en/archive/2010/08/14/schedule-a-daily-backup-with-sql-server-express/ )

[vikpaw]

Good solve