FYP Final Report v1.0.0
Copyright and All Rights Reserved To: Pee-Lo Team @2003/04
78
2.
Next, open Query Analyzer by doing Start
Programs
Microsoft SQL Server
Query Analyzer.
3.
The Connect to SQL Server dialog box will pop up. Using windows authentication to
login, click OK.
4.
Determine the name and current location of all files used by a database with the
sp_helpfile
stored procedure. Key in the SQL statements as shown below into the Editor
pane. Press F5 or click the Execute Query icon in the toolbar to execute all the statements
in the Editor pane. Then, you can identify your database files location by looking into the
filename column at the Results pane.
use peelo
go
sp_helpfile
go
Now we know that our files locations and names are:
I:\Microsoft SQL Server\MSSQL\Data\peelo_Data.MDF
J:\Microsoft SQL Server\MSSQL\TLog\peelo_Log.LDF