sqldba


{ City } bangalore
< Country > india
* Profession * dba administrator
User No # 46693
Total Questions Posted # 0
Total Answers Posted # 3

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 3
Users Marked my Answers as Wrong # 3
Questions / { sqldba }
Questions Answers Category Views Company eMail




Answers / { sqldba }

Question { 2831 }

How to know whether our backup is succesfully taken?


Answer

RESTORE VERIFYONLY FROM DISK = 'C:\temp\adventure.bak'

Is This Answer Correct ?    2 Yes 1 No

Question { Wipro, 3842 }

What is Trace flag?


Answer

Trace flags are used to temporarily set specific server
characteristics or to switch off a particular behavior. For
example, if trace flag 3205 is set when an instance of SQL
Server starts

1204: Deadlock information

Is This Answer Correct ?    1 Yes 0 No


Question { IBM, 8724 }

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?


Answer

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