Copy Data (SQL Database) into SQL 2000 Server

• Warde Wynter

  Grasshopper

  Points: 14

  More actions

  November 24, 2005 at 8:41 pm

  #102957

  Hi...I have a SQL Database on a CD, and want to 'copy' into SQL 2000 server ...how do i do this? Thanks

• Jan-155192

  SSCrazy

  Points: 2613

  More actions

  November 25, 2005 at 4:02 am

  #605822

  If your data is allready in a SQL server format, it is easy:

  Hust copy the data on disk & use sp_attach_db

  EXECUTE sp_attach_db @dbname    = N'test_db',

            @filename1 = N'c:\program files\microsoft sql server\mssql\data\test_db.mdf',

            @filename2 = N'c:\program files\microsoft sql server\mssql\data\test_db_log.ldf'

  GO

  Jan

• Calvin Duffy

  SSCarpal Tunnel

  Points: 4306

  More actions

  November 25, 2005 at 8:41 am

  #605860

  Don't forget to take off the Read-Only properties from the file after copying onto the server. Otherwise, you may end up with Read-Only database....

• Warde Wynter

  Grasshopper

  Points: 14

  More actions

  November 26, 2005 at 3:29 am

  #605934

  Thanks All!