Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««89101112

A Story of the Deleted Transaction Log Expand / Collapse
Author
Message
Posted Sunday, October 18, 2009 9:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 18, 2009 9:15 AM
Points: 4, Visits: 2
I tried to re-produce the scenario and ended up failing :-(

When DbLive.mdf is renamed to DbBad.mdf, the database name in the Mgmt Studio does not change??? As a result, I was not able to create another fake DbLive database. Please advice.

Regards,
Bharathi
Post #804781
Posted Saturday, October 16, 2010 9:12 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 30, 2013 5:05 AM
Points: 94, Visits: 232
WOW!
Really interesting;)
Nice job man;)


Thanks and regards,
Ashkan
Post #1005753
Posted Saturday, October 16, 2010 3:29 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, February 6, 2014 12:59 PM
Points: 801, Visits: 1,962
Bharathi-902714 (10/18/2009)
I tried to re-produce the scenario and ended up failing :-(

When DbLive.mdf is renamed to DbBad.mdf, the database name in the Mgmt Studio does not change??? As a result, I was not able to create another fake DbLive database. Please advice.

Regards,
Bharathi


Ther is a differnce between logocal file names nd physical file names. They do not have to be the sames. In fact most of the time they are not. The physical file name typically has an extention (.ndf, .ldf) but the locical name does not.


ATB

Charles Kincaid

Post #1005790
Posted Saturday, October 16, 2010 5:11 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:24 AM
Points: 5,872, Visits: 12,979
Hemantjemmy (8/11/2009)
Hi,
I think I have missed two word in above comment which created confusion.
What i meant was truncate & shrink transactional log file only after taking full backup.If your database is in Full Recovery Mode, it is good to truncate & shrink transaction log file regularly after full backup.


I know this an old thread bought back to life but as it was surpriseingly not picked up on before....

This is still a bad idea, a very bad idea.


---------------------------------------------------------------------

Post #1005799
« Prev Topic | Next Topic »

Add to briefcase «««89101112

Permissions Expand / Collapse