Migration SQL express 2008 to new SQL

Question

Hello,

I want to migrate an old SQL express DB to the new one for increase the storage of DB in the same server (os :windows server 2008).

Can I help me ? what is the best way, installing new SQL SERVER 2008 or 2012 for increase the storage?

karem · Answer

Hello,

thanks fir your support

but Now the version of products solarwinds are NPM 10.7,NCM 7.2.2 and NTA 4.02, there are old not new version

karem · Answer

Hello,

thanks fir your support

but Now the version of products solarwinds are NPM 10.7,NCM 7.2.2 and NTA 4.02, there are old not new version

simon.stone · Answer

You shouldn't really look at deploying SQL 2008 or 2012 as they are both end of life and more probelematically not supported for the latest versions of Solarwinds.

Realistically you should be looking at deploying for a new build SQL Server 2019 or Express 2019

It depends on how much storage your DB requires as to the SQL server model (express or full sql) you choose. There is also a cost element to consider if you are deploying full SQL.

If your DB storage requirement is higher than 10Gb you will need to deploy full SQL.

For either version migration can be done at a high level as follows:-

1) Build your new SQL server.

2) Shutdown solarwinds.

3) Shutdown the services on the express DB.

4) Copy your solarwindsDB MDF and LDF files to the approperiate disks on your new SQL server.

5) ATTACH the solarwindsDB to your new SQL instance.

6) Remove the old users from the DB security from the migrated database.

7) Create new solarwinds user in the new SQL server.

8) Change the owner of the solawrindsDB to the new solarwinds user.

9) Run the configuration wizzard on the solarwinds server and specify your new DB server, existing DB (the one you ATTACHed) and the new user you created.