topic Moving database. in Server Management - Systems Insight Manager

Moving database.

Simon H — Thu, 24 Aug 2006 04:21:37 GMT

We have a SIM 5 server where the database has been installed on the C drive, it's now approaching 3GB and causing issues for the OS as we only have about 100MB free, how can I move the DB to another drive?

Re: Moving database.

Igor Karasik — Thu, 24 Aug 2006 13:13:26 GMT

Simon,
Most likely you have full recovery model for SIM database and you don't do transaction log backups.
Change SIM database recovery model to "Simple" and shrink transaction log file.
"How to stop the transaction log of a SQL Server database from growing unexpectedly"
http://support.microsoft.com/kb/873235/en-us
After transaction log shrinking you will have very small and nice HP SIM database :-)

Anyway, without relation to SIM database size, it is good idea to move SIM database files to drive D:
"How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server"
See "Moving user databases" part
http://support.microsoft.com/kb/224071/en-us

Re: Moving database.

Simon H — Thu, 24 Aug 2006 13:21:17 GMT

Thanks Igor, I'll try that in the morning, would be good to bothshrink *and* move it, I'll let you know howI get on.