Hi,
What is the simplest way to move the whole instance from one box to another. I can stop all SQL services for couple hours, it's no problem. But I'd like to make absolute copy. So I need to move all databases, logins, roles, triggers, stored procs, packages, jobs, credentials, endpoints, proxys, etc. I need just replace the server (the box itself) with a new one.
Thank you.
How to move the whole SQL 2005 instance?
Hot Topic
- Script out dbmail configuration?
- Error while installing RS2005
- SetPolicy - Using SSRS web service
- Web Synchronization wizard
- How do I use SQL Server 2005 Express for a backend to a web site forums
- Unable to use MS SQL 2000 SA Password
- Query Runs Perfectly in SQL 2000 but not SQL 2005 (but runs fine in Query Analyzer for 2005)
- Populate field with NT Login
- Can't uninstall or reinstall nonfunctioning sql server
- Reference Dimension causing long processing times
SQL Server
- Passing data between multiple Data Flows
- MSDE no show in server explorer
- Check if database exists?
- Installing SQL Express SP1 with existing User Instances
- Install SQL 2005 Express error (ParseBootstrapOptionsAction)
- Want Hyperlink to Open in a New Window
- Disable the "All" option in a parameter
- Conditional Data Inserting
- Question on parameter.Add for an SQL Insert
- SQL Server 2005 Remote Connection Problem... Big Time.
How to move the whole SQL 2005 instance?
Nikolaj Berg Amondsen
pfpgroup
By the way, would it work:
If I delete whole folder "SQL 2005" on the new box (after installation) and then copy this folder from the old box
luis figueredo
K
marlin1