moving database

Last Post 12 Jun 2008 02:57 PM by palais2. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
xcao
New Member
New Member

--
02 Apr 2008 10:41 AM
We are going to have two new computers for two sql server boxes.

The first one:

The old sql server is 2005, new computer will also have sql server 2005.

The seond one:

The old sql server is 2000, the new computer will have sql server 2005.


What is the best option for moving the database from the older server to new server for above two cases.

We can take our server offline for doing all these.

I used to use backup and restore, but now I found it seems using detach/attach is easier.

So shall I just first detach the db from old server, and copy the .mdf and .ldf to the new server, and create the same name database and attach the .mdf fiel and .ldf file?

Thanks


xcao
New Member
New Member

--
02 Apr 2008 11:36 AM
Thank you very much
palais2
New Member
New Member

--
12 Jun 2008 02:57 PM
:-))))
ufohj
New Member
New Member

--
02 Jul 2008 06:29 AM
Nobody should ask it again...
You are not authorized to post a reply.

Acceptable Use Policy