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 |
|
csphard
Posting Yak Master
113 Posts |
 Posted - 2010-02-25 : 11:29:41
|
| I detached a database and wanted to make a copy of the detached database but could not access the folder where the mdf file exist.I think its because of my departments policy but and not sure if sql server is stoping me. This folder should be accessible for me to make a copy of it correct?Howard |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-25 : 11:40:33
|
Assuming you have folder / file permissions then after you DETACH the database then SQL Server will not prevent you copying / moving / deleting  the file. |
 |
|
|
csphard
Posting Yak Master
113 Posts |
Posted - 2010-02-25 : 11:42:15
|
| I did not understand your answer. sql server is preventing us? |
|
|
|
csphard
Posting Yak Master
113 Posts |
Posted - 2010-02-25 : 11:59:42
|
quote:
Originally posted by csphard
I did not understand your answer. sql server is preventing us?
We can attach it to another database. We just wanted to make a physical copy of it prior so that we have a backup.I hope this is understandable.Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
detached database