Hi, I have a question about the steps to duplicate and upgrade SQL server.
Now, I have a windows 2008 32bit server and runs SQL server 2005 on it. Then I would like to build another server, which is windows 2012 64bit and runs SQL server 2008 on it. I need to duplicate everything from the first server to the second one and keep both of them running at the same time, such as reports and so on.
What should I do? Any one knows the steps to finish this project?
asked Apr 19 at 09:55 PM in Default
You can use the Copy Database functionality in SQL Server Management Studio.
Right-click the database, select "Tasks", "Copy database". If you can take the database offline, you can also choose to detach it, copy the files to the new server, and then reattach the database after.
See also the Microsoft
Also you may check this
answered Apr 20 at 04:55 AM