Skip to Content
0

Databases not displaying in client systems

Oct 22, 2016 at 06:58 AM

34

avatar image

Dear Experts,

Due to less space in c drive the databases in client system not displaying. To increase space in c drive thinking to move live database from c to d drive. Need your suggestions what problems i will face if i move or is it ok.

Regards,

Karthik

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Johan Hakkesteegt Oct 24, 2016 at 07:31 AM
0

Hi Karthik,

Assuming that you mean MS SQL Server, there is no problem.

I suggest you do it as follows:

  1. Make a backup of your live database
  2. In MS SQL Management Studio create a new database. Make sure its files are situated on the D: drive.
  3. Restore the backup on top of the new database, with overwrite and make sure that the file paths are on the D: drive
  4. Press the refresh button on the login form, and see your "new" database in the list.
  5. Test
  6. Delete the old live database

Additionally, if possible you should try to make sure that the D: partition is on its own physical drives.

Regards,

Johan

Share
10 |10000 characters needed characters left characters exceeded