Skip to Content
avatar image
Former Member

Databases not displaying in client systems

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 24, 2016 at 07:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded