June 23, 2015 at 12:42 am
Hi All,
We are told that we cannot get remote access on our DB servers , can access them only via SQL management studio. But we are the one's who will be restoring all our DB's from current setup to new servers.
My Question:
1. Can we restore the DB's directly via SQL Management studio(from other server where management studio is installed) without logging into the DB server.
2. How do we set the mdf/ldf file paths, assuming we have elevated access on the DB. Is this possible?.
Any other blockers we can face?
June 23, 2015 at 1:09 am
1. You should be able to do all of it assuming the sql / agent account has the relevant access to the backup/restore folders.
2. If you have the relevant premissions you can use ALTER DATABASE statement to move the files around:
ALTER DATABASE Data
MODIFY FILE ( NAME = Data, FILENAME =
"C:\Data\Data.mdf")
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply