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

Answers to these questions Expand / Collapse
Author
Message
Posted Friday, May 25, 2012 5:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237
Hi,
I have been studying SQL Server DBA interview questions from the net and find these questions in wich I am unclear of the solutions :-

1) If a database goes down for whatever reason (assume data file is corrupt) and the database cannot be brought back online (i.e. you are in a recovery situation), what must be done first to ensure you can retrieve the latest data modifications assuming the database is set to the FULL recovery model?

ans :- meanwhile connect to the log shipping server.

2) What can you do to guarantee any backup is valid?

ans :- restore verifyonly from backup

3) What special type of page within SQL Server that is responsible for tracking (via a simple bitmap) extents that have been modified since the last "BACKUP DATABASE" statement?

I had more questions to ask ,wenever i recall, i will again post here only.

Thanks.

Regards,
Sushant
Post #1306465
Posted Friday, May 25, 2012 5:37 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 @ 2:59 AM
Points: 40,445, Visits: 36,900
Tried google? I know the answers to at least 2 of those can be easily found.


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 #1306470
Posted Wednesday, May 30, 2012 3:46 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237
GilaMonster (5/25/2012)
Tried google? I know the answers to at least 2 of those can be easily found.


i need to know 1st and 3rd answer

Regards,
Skybvi
Post #1308203
Posted Wednesday, May 30, 2012 5:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 4:10 AM
Points: 5,221, Visits: 5,119
All three of the answers to them can be found on google.

Copy your questions, place them into google and you will get the answer. I have just copied one and all three answers are on the same page.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1308271
Posted Wednesday, May 30, 2012 7:23 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, November 20, 2014 2:59 AM
Points: 728, Visits: 782
anthony.green (5/30/2012)
All three of the answers to them can be found on google.

Copy your questions, place them into google and you will get the answer. I have just copied one and all three answers are on the same page.


true dat!
Post #1308340
Posted Wednesday, May 30, 2012 11:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237
anthony.green (5/30/2012)
All three of the answers to them can be found on google.

Copy your questions, place them into google and you will get the answer. I have just copied one and all three answers are on the same page.


I dont know whcih search engine u are using or which server...BUT i can get only questions , but no answers...

Couldn't u just provide me the link.

Thanks.

Regards,
Skybvi
Post #1308502
Posted Wednesday, May 30, 2012 11:24 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 @ 2:59 AM
Points: 40,445, Visits: 36,900
https://www.google.com/search?q=what+is+page+tracks+extents+modified+since+last+full+backup

First, second, third and fourth hits.

https://www.google.com/search?q=What+needs+to+be+done+to+recover+a+database+up+to+point+of+failure

First, second, third, fourth and fifth hits.



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 #1308510
Posted Wednesday, May 30, 2012 11:28 AM
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: Yesterday @ 7:57 PM
Points: 593, Visits: 4,968
Reading comprehension is a big part of being DBA.

This is the very first link I hit on Google.

http://blogs.msdn.com/b/chadboyd/archive/2007/07/17/so-you-think-you-know-sql-administration-part-i.aspx
Post #1308513
Posted Wednesday, May 30, 2012 11:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237


Thanks a lot

Regards.
Skybvi
Post #1308523
Posted Wednesday, May 30, 2012 11:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237
Charles Hearn (5/30/2012)
Reading comprehension is a big part of being DBA.

This is the very first link I hit on Google.

http://blogs.msdn.com/b/chadboyd/archive/2007/07/17/so-you-think-you-know-sql-administration-part-i.aspx


Thanks a lot

Regards.
Skybvi
Post #1308524
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse