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 |
|
ruan4u
Posting Yak Master
132 Posts |
 Posted - 2005-02-09 : 12:12:00
|
| When i try to shrink a file it gives error 8985 - Could not locate db.mdf in sysfiles.DBCC execution completed.What does that mean.What does this affect.Can i take the Db offline?Also i noticed that DB was not getting backedup.The folder creation date is latest but there was nothing in that folder.The management plan is set to remove backups every 20 days.Please help |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-02-09 : 12:27:48
|
| Shrinkfile takes a logical file name, not a physical file name.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
|
|
|
Shrinkfile giving error