Navigation bar
  Start Previous page
 78 of 109 
Next page End Contents  

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
http://www.purepage.com Previous page Top Next page