Also, MERGE isn't available in SQL Server 2005, and our LOB systems will not migrate to SQL Server 2008 until the vendors support SQL Server 2008. We just now...

I agree with Grant.

😎

Are you using SQL Servers BACKUP and RESTORE? You may want to consider purchasing a third-party backup solution that will allow you to compress your backups files during the...

You're 1/3 of the way there. Still need sample data and expected results based on the sample data.

We can at least start looking at the query, but we need...

Save it to disk, zip it, and upload the zip file.

😎

What would really help here is the DDL (create statements) for the tables, sample data for each of the tables (as insert statementws that can be cut, paste, and run...

Not sure if MERGE is needed here. The question only indicted that a record needed to be inserted if it did not already exist in the database. Nothing...

Could just be me, but answer 2 just seemed to be the logically correct answer to the question.

😎

Not sure about the Alter (it may require a restart of SQL Server), but if your app can afford some down time another way to accomplish the move is to...

Preston (9/4/2008)

---

Lynn Pettis (9/3/2008)

---

Lookup RESTORE in BOL. If you still don't understand,...

Lookup RESTORE in BOL. If you still don't understand, let us know...

Symantics. If you restore DB2 using a just created DB1 backup, you have the same thing.

😎

I'd have to agree with DavidB. I worked in an environment where I was trying backups directly to tape. I found the disk to disk backups were faster...

Another option is HyperBac. We are using it, and it works quite well for us, and we still use standard SQL Server backup/restore commands.

Compression is about 80% and backup/restore...

sg2000 (9/3/2008)

---

To all responders:

Thanks very much for the suggestions. I chose to use the one suggested by Leo (using Restore Wizard) since it is the easiest.

Grant Fritchey: Yes, you did...