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

SQL Server Backup Questions Expand / Collapse
Author
Message
Posted Saturday, January 4, 2014 4:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 25, 2014 8:06 AM
Points: 2, Visits: 4

Please Provide details regarding below questions:
What special option/argument must be given to the BACKUP LOG command to perform this action?

What options/arguments can be specified in a BACKUP LOG statement to keep inactive log records from being truncated?

Is the sequence of data rows on given data/index page guaranteed to physically match the logical order of rows (i.e. by index key, row id, etc.)?
Post #1527804
Posted Saturday, January 4, 2014 4:22 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 489, Visits: 1,785
What are your thoughts, first of all?
Post #1527805
Posted Saturday, January 4, 2014 5:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 25, 2014 8:06 AM
Points: 2, Visits: 4
I don't Know idea regarding those questions dats'y I'm asking to know about that....


Regards,
Manikumar.
Post #1527807
Posted Saturday, January 4, 2014 9:50 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 23,299, Visits: 32,047
Have you tried looking this up in Books Online? While in SSMS press Shift-F1.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1527822
Posted Saturday, January 4, 2014 10:18 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 @ 9:27 AM
Points: 42,829, Visits: 35,960
1 and 2: Google backup log SQL Server
3: Google index data physical order (and be prepared to weed out the true from the false). Rather weird interview question.



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 #1527828
Posted Monday, January 6, 2014 3:59 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, August 25, 2014 2:50 PM
Points: 550, Visits: 1,611
Sounds like someone copied questions from a chapter review section of an exam preparation book. They might not even recognize a correct answer if the wording differed from what the author of the book wrote.
Post #1528282
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse