Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am currently running SQL server 2008 (SQLserverold) which homes databases for systemn center Service Manager 2012 Datawarehouse. This server is very old and needs to be decommisioned. Prior to decomissioning the serve, the databases have to be migrated to another clustered SQL server with two nodes(SQLServer1 and SQLserver2). I am not a DB admin no experience in SQL, and I have been given the task of migrating the Databases on the old server to the new custered environmnet. Can some point me to the right direction as to how i could do this. Step by step instruction would be helpful.

Thank you in advance

confy

share|improve this question
1  
"not a DB admin, no experience with SQL, please give me step-by-step instructions" You just violated just about every rule we have on this site. Please read the FAQ. –  pauska Sep 19 '12 at 9:39

1 Answer 1

  1. Open up SQL Server Management Studio.

  2. Connect to the old server.

Either: Backup the current databases: - Right Click on the Database - Select Backup

Or: I assume there will already be a maintenance plan in place taking backups, find where this is putting its backups (.bak files).

  1. Copy the backup files to the new server.

  2. Connect to the new server in SQL Management Studio.

  3. Right click on Databases and select restore.

I would recommend that on the new server you:

  1. Split the log and data files onto separate disks and spindles to ensure there is no blocking.
  2. Setup a maintenance plan to ensure you have frequent backups of your data. (Daily ideally), you will also need to make sure that this data is copied of the server if the server completely fails.
  3. Put the Data and Log files into separate subfolders. Not necessary but easier to manage.

However, seeing as you have no idea how to do this and this is a very simple job, I would definitely recommend getting a professional in to do this for you.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.