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 |
|
vicki
Posting Yak Master
117 Posts |
 Posted - 2002-04-12 : 14:19:04
|
| Hi,In SQL 6.5 when you created the DB you need to created the Database Device first that inluded 2 filesone is name.DAT, other is name_log.DATSome how I created the extra one but then I forgot to deleted it and now how Do I find out which Database Device is associated with that DBFor example: The database name is DBDevice: DB.DAT, DB_Log.DAT, DBDat.DATI know there is extra one but don't know with one is the extra. In SQL 200, you can run: sp_helpfile then it returns these infor for you but that dosen't work in SQL 6.5 because when I apply the same command I got the error "Stored procedure 'sp_helpfile' not found."So what is the command to return the File name for the DB in SQL 6.5?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-12 : 14:44:35
|
| Try sp_helpdb and sp_helplog, they should give you that information.Just to clarify: a device is a single file; you cannot create a single device that contains 2 or more files. You can however create a database that resides on more than one device, and you can also create more than one database on a single device. |
 |
|
|
|
|
|
Database Device