My Data Base Gone. SOS PLease
some one has deleted my database in sql server 7.0
now I only have two file ,those are in :
..\sqlserver7\Data\myDB_Data.mdf &
..\sqlserver7\Data\myDB_Log.ldf
Can I gain my database completly again?
Networks
some one has deleted my database in sql server 7.0
now I only have two file ,those are in :
..\sqlserver7\Data\myDB_Data.mdf &
..\sqlserver7\Data\myDB_Log.ldf
Can I gain my database completly again?
by m2
try following from Query Analyzer:
sp_attach_db 'myDB', 'c:\MSSQL7\Data\myDB_data.mdf','c:\MSSQL7\Data\myDB_log.ldf'
Good luck to you!
by davood_f
by ron navon
Dear Sir,
Keep the mdf and ldf file in the side, make a data base with the same name, stop the services of SQL change the rename the new mdf and ldf, copy the old mdf and ldf.
restart the server.
I hope that is help you. Ron
by davood_f
by davood_f
This discussion is closed to new replies.
Sort by Trending