Moving SQL Database

duckfather

Ok, so I've only seen posts about this with dead links.

I've just had to physically move our Orion server to a different site. At the moment, this server is still using the SQL database at the origonal site over our WAN. I need to move this database to the local SQL server at the same site as Orion is now at.

Anyone know how to do this / what any pitfalls are?

Thanks in advance.

Andy

ftsang

You can use the Orion database manager to perform a database backup on the current server, copy the backup file to the new SQL server you're going to use and then run a restore from the Orion database manager. After the restore you just run the configuration wizard to point Orion to the new SQL server. It's pretty straightforward. I've done it before with no issues.

There are video tutorials on how to do the backup and restore on the solarwinds website

www.solarwinds.net/.../Tutorials.htm

quote:Originally posted by duckfather Ok, so I've only seen posts about this with dead links. I've just had to physically move our Orion server to a different site. At the moment, this server is still using the SQL database at the origonal site over our WAN. I need to move this database to the local SQL server at the same site as Orion is now at. Anyone know how to do this / what any pitfalls are? Thanks in advance. Andy