March 1, 2011 at 2:43 pm
Hi all,
we have sql server 2008 r2 installed on server which is not ours.we are getting a new server this year and want to install everything on that.
can anyone guide what are the steps i need to take for this?
i have schedule jobs on the old server how should i move from oldserver to new server..
or please suggest any me any article or links since i didnot find perferct one.
March 1, 2011 at 2:53 pm
Backup and restore your databases from the current server to the new server.
You will need to migrate security (logins, users, certs,roles, proxies etc)
You should script out your jobs and recreate them on the new server.
Take inventory of your SSIS or dts jobs so you can migrate them if you have any
Do you run reporting services currently? If so, you should backup and restore the databases. But additionally, you need to backup the certificate/key for SSRS and import that into the new server (less painful than to not back it up).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 1, 2011 at 2:55 pm
Yes we do have reporting services and reporting database that support ssrs .
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply