Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-19 : 09:09:43
|
| MissWain writes "Hello guys,I need some expert advice for a task that's going to be performed. We have an SQL Cluster that's going to be reformated and a brand new install of SQL Server is going to be put in there. I am looking for the best method to restore all the System(Including Master) databases, and user databases to this new cluster without breaking any logins and losing any data.Please if you have any documentation about this, let me know.Basically, I am going to backup the master, model, msdb and user databases from the old server and once the new server is set up and SQL Server Installed, I'll like to restore all the above databases to this server.Thanks in advance." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-19 : 10:53:47
|
| try http://www.sqlteam.com/Item.asp?ItemID=9650Google is a good thing to try a search with too.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Moving Databases to a new Server.