I will give up on this then and tell my boss we need another SQL 2005 server if we are going to have any type of failover server, cold, warm,...

I find this interesting. I was installing an application today that specified SQL 2000, and instead of SQL scripts to build the databases, it shipped with prebuild DBs in...

I'm sold. I would like to look into scripted backups.

I'll start looking around in the Scripts <---

David

"why truncate the log before the backup? "

Yeah, that's what I was thinking too. Like I said I didn't set this up, just trying to figure out what to...

SSCarpel - thanks, that's what I was thinking. I don't want to assume I know best, but when you see something that is so very different than what I...