Backups

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » SQLServerCentral.com Announcements » Backups

12 posts, Page 1 of 2

1 2 »»

Backups

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Saturday, April 19, 2008 1:18 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the item Backups

Post #487598

Ramkumar.K

Posted Monday, April 21, 2008 12:07 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, April 03, 2012 3:37 AM
Points: 369, Visits: 161

Hi..

While we are taking Full Backup on a DB, I hope the Log files also be got backed up. Then How it is possible to run a full back up and Transaction log backup simultaneously???

Will there any conflict come???

Can any one explain about it??

Ramkumar . K
Senior Developer
######################
No Surrender... No Give Up....
######################

Post #487715

rene-500237

Posted Monday, April 21, 2008 4:56 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:26 AM
Points: 2,300, Visits: 1,099

Hi all,
as far as I can read the table log backup and DB backaup cannot be run at the same time. And if so I like to get my 2 points ;)
Regards

Post #487825

steveb.

Posted Monday, April 21, 2008 5:21 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 8:56 AM
Points: 2,802, Visits: 7,110

check the link, according to the diagram they can.
There is no black dot this means that they can be run at the same time.

Post #487836

rene-500237

Posted Monday, April 21, 2008 5:35 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:26 AM
Points: 2,300, Visits: 1,099

normally I read the dots as 'is working OK' and not vice versa. w00t

Regards

Post #487846

steveb.

Posted Monday, April 21, 2008 5:38 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 8:56 AM
Points: 2,802, Visits: 7,110

yeah, i had to read it a couple of times as well :)

Post #487850

bitbucket-25253

Posted Monday, April 21, 2008 7:28 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:49 PM
Points: 5,122, Visits: 20,362

Dots or no dots from:
http://msdn2.microsoft.com/en-us/library/aa225964(SQL.80).aspx
The following text:

Note During a full database or differential backup, Microsoft® SQL Server™
backs up enough of the transaction log to produce a consistent database for when the database is restored.

Now I know the question is can a backup be started ... does not ask if it must be successful or even completed, but that is implied for why else would you do it.

So my question is: How does SQL backup a portion of the log file when the log file can not be backed up due to an open transaction.

Will somebody please explain.?

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #487946

Alan Vogan

Posted Monday, April 21, 2008 10:03 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:44 AM
Points: 1,079, Visits: 513

The real answer to this question? The user doesn't know anything about full back-ups or log back-ups. I've got 3000 other things on my plate. They'll be able to run that report in about 20 minutes... ;)

Post #488080

rlondon

Posted Monday, April 21, 2008 2:14 PM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:55 PM
Points: 417, Visits: 1,125

The following link also shows that the two can be run concurrently
http://msdn2.microsoft.com/en-us/library/ms187900.aspx

Post #488225

Steve Jones - SSC Editor

Posted Monday, April 21, 2008 9:27 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:19 PM
Points: 31,526, Visits: 13,863

The database backup backs up all pages, then it scans the logs, grabbing pages needed to cover transactions that have taken place since the backup started. In this way it has a consistent backup while allowing users to still work on the database. The full backup does not change or alter the log, which is why you need log backups to clear the log. And this is why the log backup can be run at the same time.

Would you do this? I have seen scheduled conflict, though it's not likely you would purposely do this.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #488320

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions