If i have two mdf,ldf files path. and i modify the path from 1st path to 2nd path
Then i should be able to access only 2st path tables,sp's etc. but i am able to access both the path info...
Is it the way or some thing wrong i am doing?
this is the process i follow:
ALTER DATABASE mydb
MODIFY FILE (NAME = mydbdev, FILENAME = 'E:\SQLData\mydb.mdf');
ALTER DATABASE tempdb
MODIFY FILE (NAME = mydblog, FILENAME = 'E:\SQLData\mydb_log.ldf');
2. Stop and restart the instance of SQL Server.
by this above steps i am able to change the path but i am able to see all the information from the old mdf file.
any one Please clarify my doubt