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

Where that backup goes.. Expand / Collapse
Author
Message
Posted Wednesday, August 4, 2010 11:48 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 6, 2014 3:58 AM
Points: 1,202, Visits: 1,941
When we use backup with NO_Log.
Where that backup goes..

Can explain ...


Thanks

Post #963987
Posted Wednesday, August 4, 2010 11:53 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 17,825, Visits: 15,758
It doesn't go anywhere. This was a method for clearing out the log. It should not be used and it is being deprecated.
http://technet.microsoft.com/en-us/library/ms186865.aspx




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #963992
Posted Thursday, August 5, 2010 12:00 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:37 PM
Points: 40,210, Visits: 36,619
guptaajay1985 (8/4/2010)
When we use backup with NO_Log.
Where that backup goes..


Nowhere. That command says to SQL 'do as if you were doing a log backup, but throw away what you would have backed up in if that option wasn't there.'



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #963998
Posted Thursday, August 5, 2010 12:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 6, 2014 3:58 AM
Points: 1,202, Visits: 1,941
Suppose from a long time we havent taken the full and txn log backup,and now we are not able to do the even dbcc shrink as well as no full backup due to no disk space available then we use this No_log,but on using it ,it truncate the logs since full backup.

suppose my database is just corrupted after running command backup log with NO_log , how Will I restore my databse?

This is my question...


Thanks

Post #964014
Posted Thursday, August 5, 2010 1:58 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:37 PM
Points: 40,210, Visits: 36,619
guptaajay1985 (8/5/2010)
suppose my database is just corrupted after running command backup log with NO_log , how Will I restore my databse?


Restore your last full backup and any transaction log backups that you do have. Same way you restore any other time. Since that command breaks the log chain, you won't be able to take a tail-log backup and so the best you'll be able to restore to is the last transaction log backup that you had taken.

You shouldn't need to run that command. If you want to auto-truncate the log, switch the database to simple recovery model. Then sort out the large log file, switch the database back to full recovery, take a full backup and set up log backups.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #964038
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse