Flo,

Here is what I figured out yesterday afternoon:

My script did not have any GO statements in it. This allowed me to set a scalar variable to use in several...

I figured it out.

Adding the "-m1" parameter to the sqlcmd command suppressed the "Changed database context" message.

Adding SET NOCOUNT ON to the query suppressed the "(1 rows affected)" message.

NOTE: As...

This whole exercise came about because I wanted to do a COPY_ONLY backup.

It occured to me that it must have way too much work for Microsoft to add a check...

I feel reasonably stupid but in my defense, I did clearly state that I am a 2005 novice ...

I am, however, certain that I will always remember that the check...

- It means that a backup run completely from the Management Studio GUI work perfectly (executes for a minute or two) but if I click on the 'script' button and...

You have officially stepped outside my wheelhouse. What I was trying to do should have been straightforward and simple.

I have actually hand-type simple backup commands for different paths and different databases and none of the scripts executed properly.

Removed the NOFORMAT, NOREWIND and SKIP directives (wanted INIT) and got the same result:

BACKUP DATABASE [JDE_EGEN] TO DISK = N'H:\SQL2005\EGEN.BAK' WITH INIT, NAME = N'JDE_EGEN-Full Database Backup', STATS...

Absolutely.

BACKUP DATABASE [JDE_EGEN] TO DISK = N'H:\SQL2005\EGEN.BAK' WITH NOFORMAT, INIT, NAME = N'JDE_EGEN-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

GO

Note: My purpose for doing this in...

OK, Thanks. The devil is in the details in the whole backup / recovery area and I am trying to get my DR procedures down before I ever have...

I'm still not clear on the issue. This video talks specifically about only full backups and transaction log backups.

I thought I was beginning to understand the nuances of backups / LSNs until I stumbled upon this video:

http://www.sqlservercentral.com/articles/Video/63811/

It talks about the pitfalls of running ad-hoc backups and, if I...

Thank you very much for the on-point answers.

Two follow-ups:

1. Is removing the inactive entries on a full backup an option (which I would want to NOT select) in SQL Server...

If all things were basically equal, I would be inclined to go with SQL Safe simply because we are already a customer using their SQL Defrag product (which, curiously, seems...

Thanks for all the replies and the link to the previous thread on this topic. I had never heard of the Hyperbac product but it looks very interesting.