I have delated my transaction log file (it was 1,3 Gb big). I'm trying everything to recover my DB without success..
Does someone could help me
thanks a lot, GiovanniHi,
Did you detached the database and deleted the transaction log file, or just
stopped SQL server and deleted the file.
If you deleted the file after detaching then usethe system procedure to
attach the database with single MDF file. (Make it a try even if you
have deleted the file with out detach)
sp_attach_single_file_db 'DBNAME','location and filename of MDF file'
(Refer books online for more info
The command will fail incase if you have more than one LDF otr MDF file.
If you have mutiple MDF/LDF files you may need to restore from last
successful database backup or contact Microsot support.
Thanks
Hari
MCDBA
"Giovanni BO" <giovanni.gambaro@.businessobjects.com> wrote in message
news:955A7588-A85F-4DB4-BB2C-802780350503@.microsoft.com...
> I have delated my transaction log file (it was 1,3 Gb big). I'm trying
everything to recover my DB without success...
> Does someone could help me?
> thanks a lot, Giovanni
No comments:
Post a Comment