copy database

I guess the easiest way is to use backup/restore feature of SQL server.
Management Console window should help you, if not SQL server Books online is your friend.

HTH
/Kejpa
 
kejpa said:
I guess the easiest way is to use backup/restore feature of SQL server.
Management Console window should help you, if not SQL server Books online is your friend.

HTH
/Kejpa
Click to expand...


The books that i found are all teach on SQL Statements
 
Stop your SQL SERVER using the Service Manager, Go to the Microsoft SQL Server folder in program files. Open the MSSQL folder and then the Data folder. Copy your two files, - _Log, _Data - and move to a new machine.

Copy the two files into the exact folders in the new machine, verify that they are not readonly ( go into file properties). Open SQL Server and navigate down to the Databases folder. Right click and select All tasks, Attach Database. Use the button supplied to navigate to the two files you copied over and hey presto your database is now on the new machine.

Mike55
 
mike55 said:
Stop your SQL SERVER using the Service Manager, Go to the Microsoft SQL Server folder in program files. Open the MSSQL folder and then the Data folder. Copy your two files, - _Log, _Data - and move to a new machine.

Copy the two files into the exact folders in the new machine, verify that they are not readonly ( go into file properties). Open SQL Server and navigate down to the Databases folder. Right click and select All tasks, Attach Database. Use the button supplied to navigate to the two files you copied over and hey presto your database is now on the new machine.

Mike55
Click to expand...

Thks a lot
 
SQL server Books online isnt really a book its all the help you ever needed for handling SQL server in help files probably already installed on your computer. Look for it in the same place under the Start|Programs|SQL Server(?) as you use to start Query Analyzer.

/Kejpa
 
mike55 said:
Stop your SQL SERVER using the Service Manager, Go to the Microsoft SQL Server folder in program files. Open the MSSQL folder and then the Data folder. Copy your two files, - _Log, _Data - and move to a new machine.

Copy the two files into the exact folders in the new machine, verify that they are not readonly ( go into file properties). Open SQL Server and navigate down to the Databases folder. Right click and select All tasks, Attach Database. Use the button supplied to navigate to the two files you copied over and hey presto your database is now on the new machine.

Mike55
Click to expand...

Is that possible for the database file to store in different folder, instead of the "data" folder?
 
miwaypro said:
Is that possible for the database file to store in different folder, instead of the "data" folder?
Click to expand...

Should be no problem, just simple browse to the new location from SQL SERVER. If you are messing with the database, just make sure that you keep a back-up with you.

Mike55.
 
mike55 said:
Stop your SQL SERVER using the Service Manager, Go to the Microsoft SQL Server folder in program files. Open the MSSQL folder and then the Data folder. Copy your two files, - _Log, _Data - and move to a new machine.

Copy the two files into the exact folders in the new machine, verify that they are not readonly ( go into file properties). Open SQL Server and navigate down to the Databases folder. Right click and select All tasks, Attach Database. Use the button supplied to navigate to the two files you copied over and hey presto your database is now on the new machine.

Mike55
Click to expand...

In ur post above u ask to select the "Attach Database". but can i use the
"restore database? what are the difference?
 
You would use the restore option if you had previously backed up the database, if you have just copied the files the the attach option is the one to use.
 
Back
Top