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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2005-05-24 : 21:25:36
|
| Hi,My servers harddrive space is filling up so I was looking to move some databases over to another disk.anyhow, I opened up the /data directory and noticed a database like:'mydatabase_01012005.mdf'I must have created a databae like that before i guess, anyhow, the file is 1.5 gigs. I have a database that I'm using that is named 'mydatabase'. I tried to move that file and it said it was being used. I am not using that db as far as I know, and it doesn't even show up in EM.thoughts? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-24 : 21:30:41
|
| Have a look at master..sysaltfiles.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2005-05-24 : 21:55:40
|
| using a query? please explain... |
|
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-05-25 : 02:23:22
|
USE mydatabaseGOSELECT * FROM sysfilesORAs Nigel suggestedSELECT * FROM sysaltfilesAndyBeauty is in the eyes of the beerholder  |
|
|
|
|
|
|
mdf and ldf in Data directory but not being used?