July 14, 2009 at 4:46 pm
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.
July 14, 2009 at 5:42 pm
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
July 14, 2009 at 11:49 pm
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