Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by James DiMauro » A Story of the Deleted Transaction Log
Add to briefcase
114 posts, Page 12 of 12
«««89101112

A Story of the Deleted Transaction Log Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Bharathi-902714
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: 3, 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
ashkan siroos
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: Wednesday, May 01, 2013 12:54 AM
Points: 93, Visits: 229
WOW!
Really interesting;)
Nice job man;)

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


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 9:18 AM
Points: 772, Visits: 1,825
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
george sibbald
Posted Saturday, October 16, 2010 5:11 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 5,264, Visits: 11,190
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
114 posts, Page 12 of 12
«««89101112

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.