Moving a *huge* table to another server

[raze]

Hi there .... <br><br>I've been tasked with moving a table of 11 million records to a new server, which is located remotely.<br><br>We tried using the Import/Export tool, but a direct link would take quite some time (and ended abruptedly when our leased line choked)<br><br>We also tried exporting to a text file, FTPing to the new server, then importing to the empty table - but the export routine generated a file with errors in it (and it was so big, we couldn't open it to take a look!), so SQL server couldn't import it at the other end.<br><br>So, I'm a bit stumped; but I wonder if it is possible to take the database file, zip it up and move it manually. I notice that data directort has MDF and LDF files ... can I move those and set up the server at the other end to see them?<br>

 

[LuvASP]

Why don't you do it in chunks.

 

[jnicho02]

You could move the whole database with sp_detach_db and sp_attach_db.... <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>my

home</a><br>