Where that backup goes..

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Where that backup goes..

Where that backup goes..

Rate Topic

Display Mode

Topic Options

Author

Message

forsqlserver

Posted Wednesday, August 04, 2010 11:48 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186, Visits: 1,852

When we use backup with NO_Log.
Where that backup goes..

Can explain ...

Thanks

Post #963987

SQLRNNR

Posted Wednesday, August 04, 2010 11:53 PM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732, Visits: 12,329

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 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #963992

GilaMonster

Posted Thursday, August 05, 2010 12:00 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 2:45 PM
Points: 37,635, Visits: 29,885

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

forsqlserver

Posted Thursday, August 05, 2010 12:35 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186, Visits: 1,852

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

GilaMonster

Posted Thursday, August 05, 2010 1:58 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 2:45 PM
Points: 37,635, Visits: 29,885

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 »

Permissions