SIMS Restore

[oxide54]

Hi Everyone,

 

just finished spending all day restoring the SIMS server so I thought I document what i did in case it helps someone else.

 

----------------------------------------------------------------------------------------------------

 

We're using Windows 2003, Symantec Backup Exec, SIMS, SQL Server 2005.

 

----------------------------------------------------------------------------------------------------

 

Without going into to the cause the old VM would still boot but the database had it, so i decided to disconnect the NIC from it and build a new VM, meaning if the backup wouldn't restore I still had the broken server maybe to ring crapita etc.

 

----------------------------------------------------------------------------------------------------

 

Build new VM, Create disk configuration as before C: drive 50gb, e: drive 150gb.

 

Installed :

Windows 2003 Server

Service Pack 2

Remote Agent for Backup Exec

Formatted e: drive

 

--------------------------------------------------------------------------------------------------

Restored E: drive first.

Restored C: drive.

Re-installed Backup Exec agent, reset IP configuration.

Restored System State and Shadow Copy Components

Re-installed Backup Exec agent, reset IP configuration.

--------------------------------------------------------------------------------------------------

Went to SIMS SQL data directory renamed master.mdf mastlog.ldf model.mdf modellog.ldf

 

renamed master$4idr to master.mdf

mastlog$4idr to mastlog.ldf

model$4idr to model.mdf

modellog$4idr to modellog.ldf

 

 

cleared all archive and readonly bits.

 

started SQL server ( make sure you have the right instance if you went through the SIMS migration a few years ago)

 

Run backup job to restore all databases apart from master,

 

Settings -> Leave database ready to use

Overwrite existing database

Take database offline

 

Let it run

 

---------------------------------------------------------------------------------------------------

 

And we had SIMS back, made a ghost of straight away.

 

 

hope this helps someone.

[oxide54]

sorry just noticed the MIS forum, doh

[rad]

Cheers for that, at least a Edugeek search will help someone in tim eof need