Is this a one time thing or regular? If it's one time, use the data export, and import, wizards.

You can use those if it's regularly, but I might suggest something...

Gail has the right idea. My Computer/Manage/Services, check for the MSSQLServer service and see if it's running. You can netstat-a and see if the listener is running.

Are you connecting locally,...

You can do this, but it's asking for trouble. It increases your surface area and potentially exposes you to sql injection.

The only thing I might do it read the "from"...

You wouldn't use shrinkfile to move data. It reclaims physical file space for the OS, does nothing to effect the data.

The problem is that unless you add data equally to...

How are the jobs running? You might check the client configuration utility for the default protocols.

Please post in the correct forums. Move to SS2K Admin

Mike has contacted me and should be sending me some code. Not sure if it's more than attached above, but I'll get it posted and drop a note in here.

Those numbers are likely falling. Given the recent banking issues, seems like we're getting less and less bank offers in the mail every day. Less stuff to steal.

As of now, no one really knows. I'm not sure if this is SQL 11 or SQL 10.5 right now.

And be sure you know what columns are in the index before you drop it.

Read books online for the parameters for the create index command. You might want to note the fillfactor before you do this.

Good resume

Good backup

you only need one.

Get Log Rescue, I think it works on v7 as well. Read the logs. Then go get backups setup.

You don't need to use robocopy. Copy the files manually.

Are there people connected to the database?

If you want to move the files, detach the database, be sure you kill the users from it, and then attach it from the...

Pathing is based on the server, not the client. you might need to copy the file to the server.