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...

Go to redgate.com. If memory serves, they have a free tool that will read a SQL Server 2000 transaction log file (if your database is using the full or...

GilaMonster (9/3/2008)

---

The problem with this is that the repeated (Column = Variable or variable = constant) expressions confuse the optimiser's estimations of rows affected (on 2005 definitly, not sure about...

What this does (colOne = @num1 or @num1 = 0) does is create a conditional where clause statement. If the value of @num1 = 0, you get all rows...

Geez, get side tracked by work for a couple of minutes and someone beats me to...