Another just curious: How do you plan on promoting your changes to your structures back to the production database?

Based on your original post, DTS, as Greg stated, should work...

You can also backup the old database and restore it to the new database. Depending on the volume of data, this may be quicker. Just curious, why did you create...

Search for files modified on a certain date, asuming you know when the backup was taken. If you specified a file destination without an extension, I do not believe a...

As John stated, we're not sure what exactly you are trying to do. To simply view the database and it's contents, a suggestion has already been given. If trying to...

Not a lot of info to go on. How much memory is installed on the server? Is there adequate disk space available? What else is running on the server?

Check these...

I tend to say "sequel" when talking about the overall environment and SQL when talking about coding. Think I'm simply going to use squeal for both from now on! That'll...

And from a referential integrity standpoint, if the identity field is used as a foreign key elsewhere, you're going to have to either issue updates to each of the references...

Can you restore the backup on another server and verify that the backup is good?

More frequent log backups do not reduce the size of the log but does reduce the amount of data contained within the log. In order to keep the log reasonably...

For what? Better NIC cards, better routers, better cables. Kind of an open ended question. Is SQL not returing data quick enough? Could be a poorly written query, slow disks,...

It's definitely permissions, either the account doesn't have access to the server or to the particualr share on that server. Check these links.

http://www.microsoft.com/technet/archive/winntas/support/acdenid2.mspx?mfr=true

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2288846&SiteID=17

Just a followup. This was on the freeware version of VMWare not ESX as I originally stated. We rolled a different server to ESX about two weeks ago without issue....

What would define a unique row, simply contract? Can you provide table layouts and some sample data? It's not a hard world, just different. Stick around, there's a lot of...

I agree with SQLZ. If you want to maintain any amount of control, don't let them run it against production. Give them a daily, refreshed dev environment, have them run...

Check this out - a hotfix for sp4. Seems to be what you're experiencing.

http://support.microsoft.com/kb/924664