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 12»»

Backups Expand / Collapse
Author
Message
Posted Saturday, April 19, 2008 1:18 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Backups
Post #487598
Posted Monday, April 21, 2008 12:07 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Monday, April 21, 2008 4:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:29 AM
Points: 2,488, Visits: 1,135
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
Posted Monday, April 21, 2008 5:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
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
Posted Monday, April 21, 2008 5:35 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 4:29 AM
Points: 2,488, Visits: 1,135
normally I read the dots as 'is working OK' and not vice versa.
Regards
Post #487846
Posted Monday, April 21, 2008 5:38 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
yeah, i had to read it a couple of times as well :)
Post #487850
Posted Monday, April 21, 2008 7:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:12 AM
Points: 5,473, Visits: 23,558
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
Posted Monday, April 21, 2008 10:03 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 9:11 AM
Points: 1,082, Visits: 535
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
Posted Monday, April 21, 2008 2:14 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 9:16 AM
Points: 417, Visits: 1,143
The following link also shows that the two can be run concurrently
http://msdn2.microsoft.com/en-us/library/ms187900.aspx
Post #488225
Posted Monday, April 21, 2008 9:27 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:02 PM
Points: 32,831, Visits: 14,971
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 »

Add to briefcase 12»»

Permissions Expand / Collapse