Monday, March 12, 2012

How to load a big database?

Hello,
Does everyone have experience to load a big database? My SQL Server 2K is running on W2K. The database is 4GB, and the biggest table has 12 million records. Thanks a lot.
ytzBCP utility|||What does "to load a big database" mean?|||What does "to load a big database" mean?
Please explain exactly what do you want to do .|||"to load a big database" is to import a new big database from another SQL Server.

Thanks everyone|||Full back up the primary data base. And than restore the .bak file in the target server ( it may be take sometime but it always work).|||If you can spare the downtime, close the SQL Sever Services,
go to your Data and Log file and copy to your destination DB and attach it.

There are many ways to do this, but I prefer this way as its clean, and
does not be a burden to the existing DB for extra processing if using import.|||detach/attach (or like mentioned shutdown your sql server service and copy to the destination), copy database wizard, bcp, bulk load, dts ...

No comments:

Post a Comment