how to migrate a 2005 SQL DB to a new 2005 SQL Server
I need to move a SQL database to a second SQL server. Both servers are under utilized and I would like to consolidate them. There is only one db on Server A and 3 db’s on server B, so obviously, I’m looking to move the db on Server A to Server B. I would like to provide minimal downtime and I’m not sure if there is a way to do that by mirroring or just simply backing up the db and moving it over to Server B. I would also like to make it as transparent as possible to the users. Your advise is greatly appreciated.
Last Comment
If you have Litespeed tool, you could take full back of desired db and restore it wherever you want.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you Swindle for your help. I will be disusing our options with the users accessing this db.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
sp_detach_db @dbname= 'database_name'
Copy the files Data files are databasename.MDF, databasename.LDF to the new server then run:
sp_attach_db
@dbname= 'database_name',
@filename1='Drive:\FullPat