Quote:

---

Never, ever use GOTOs in scripts.

An 'sa' admin account with empty password is a huge security risk!

Why not run the backups directly from within SQL Server Enterprise Manager as a scheduled maintenance task?

---

I used the GOTO command to filter by wksta but the condition can be eliminated.

And YES the 'SA' has a password(it's not typed in)

I didn't use the enterprise manager to do the backups because it's only a part of a multilevel script, and at the end it compresses the database using winrar (just saving some tape space).


Thanks for the advice...