Internal Drives are definately better, instead of hanging a external via usb or firewire port. Are your drives IDE or SCSI?

This does not sound like a robust...

What you have is identity field that is automatically creating the numbers in your ID column. In order to ensure the proper match, you need to set identity insert...

You are correct, database backup is not what you want. However, there are a couple of options, you can write an SSIS package to do this, especially if both...

Jeff

It just so happens, I needed to use this today to ensure all dates were extracted the same way that had two different formats, MM/DD/YYYY or YYYY/MM/DD as the flat...

As stated before, SQL Server does not back up over the network very well and is not recommended. The best way to do so is to backup locally and...

Looks like you need to do an import, not a backup restore. You can do this utilizing the Integration Services tool provided, where you can set it up to...

You need to open SQL Server 2005 Surface Area Configuration and set it up to allow remote access. you can reach the SQL Server 2005 Surface Area Configurations...

Don't forget the step to perform an immediate trans log backup as the last real trans log backup you have is at 4:30 so you can only recover to that...

May I ask a question, why are you only performing differential backups after completing your first full backup, especially over such a large time period.

As stated previously, you should only...

Jeff

That is very robust and you are correct as usual, that will handle most of the conversions and should error on the ones it doesn't. Not sure if he...

Matt

I agree with you on the BAD practice of doing so, however, when I'm doing data profiling, I sometimes store dates as varchar, especially when coming from a non...

The first question to ask yourself is how much time do you have before the databases are needed again. detach/retach is great if you have the time, backup restore...

Andras

Good point, but the poster said he had a backup. I suspect as you, that he has at least one CSV file that needs to be imported, not a...

This is the constant battle between System administrators and DBAs. It normally happens when one of the positions is filled by a new person.

DBAs need to have some admin...

Those look like Full database backups. Log backups are very different. First check to see if you are running in Full mode, then check to see if you...