Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to check what was the last restore transaction LSN on
Log-Shipping and Mirroring when we doesn't have a Monitor
server and Witness server?

Question Posted / sqldba29

Answers were Sorted based on User's Feedback



How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn&..

Answer / narasimha

Select redo_start_lsn from sys.master_files where
database_id = db_id('SecondaryDatabaseName') and type = 0

Is This Answer Correct ?    4 Yes 1 No

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn&..

Answer / sunil

Narasimha, Thank you So much

I will very appreciate if you will send some daily usage
SQL DBA Queries like this. My mail ID is sqldba29 @
gmail.com

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is 3nf normalization form?

0 Answers  

How to defragment indexes with alter index ... Reorganize?

0 Answers  

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

How to get a list of columns in a view using the "sp_help" stored procedure?

0 Answers  

Does a sql server 2005 select statement require a from?

0 Answers  

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

Explain about nested stored procedure?

0 Answers  

Explain the types of indexes.

0 Answers   Accenture,

Tell me what is de-normalization and what are some of the examples of it?

0 Answers  

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

How many types of the database links?

0 Answers   MCN Solutions,

For more SQL Server Interview Questions Click Here
Categories