Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2011-09-15 : 18:36:01
|
| We have a database which is wrongly placed of its data files by analyst on to C Drive (which is OS Location).Now being given the new user drive want to transfer the Data files of this database.The Problem is based on this Database the application from the front-end is depended.May I know from experts will change of the physical location of the database from C to D Drives; as a result will there be any impact on the application accessibility from this database.Thanks All. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-15 : 19:57:51
|
| Database will be unusable while you move it.See this article |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2011-09-18 : 18:32:36
|
| Since Database is in C Drive (Which is not correct Drive for storing the Data files), then how to MOVE them to different directory.Please Suggest, Thanks |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2011-09-18 : 18:37:04
|
| Will the Detach / Attach to the Changed locations work?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-19 : 00:46:37
|
| it will work. but only problem is there will be some downtime before application becomes available again. So you need to plan this activity in such a way that its done out of main working hours.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Changing the Database location