Stored procedures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I want to formate my laptop, does anybody know how i can save my stored
procedure and the sql database of a web project of mine??

thx

regards

patrick
 
hi
Detatch your databse .(Right click ur database >Al task>detatch database.)
use windows explorer to find the corresponding mdf and ndf files of your
database.
most probably there wont be an ndf file.
back up the files in some CD.
afterformatting and installing the sql server you can attach the files you
backed up.

regards
ansil
 
Now i have detached the database and the database is away from my Enterprise
Manager but i do not find the database again??? i do not have to quote any
directory where i want to detach my database or anything else. where is my
database??:((

regaards

patrick
 
For sql server, if you used the default install, it would normally be:
C:/Program Files/Microsoft SQL Server/MSSQL/Data

In addition to the .mdf file,
you may also find an .ldf file. If you do, back that up as well... it's
your log file.

--- Nick
 
Back
Top