Moving files for database

  • I have a database with tables full of data. What I need is to move physical files (mdf, ldf) from one drive to another from within database (or running server). The method of detach/copy-files/attach_db does not work because I don't have access to file system.

    Is it possible to do it something like alter database, alter file, etc ? Or in SSMS ?

    Thanks.

  • Without access to the file system, your options are either backup/restore, copy database wizard (without using detach/attach method - which nobody really has had any success doing), copy database wizard using detach/attach - which should work without needing access to the file system directly), or synchronization tool such as Redgate's SQL Data Compare and SQL Compare.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • I guess, Backup / Restore is the best bate here and you can also restore latest t-log to get data close to current.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply