Sql Server Guide for DBA

Wednesday, January 29, 2014

SQL - Find out database restored history

Posted by Vishal Patel at 7:38 PM

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Popular Posts

SQL Server - Interview Questions and Answers . (Updated in 2018)

SQL Server DBA interview questions and answers.. Lets help other dba to find their dream job. Tell me about your self. - Most...
What is CXPackets Wait Type?

CXPACKET waits occur when a parallel query is executed and one or more threads have to wait on one of the other threads to complete. ...
Using Distributed Replay to load test your SQL Server–Part

Have you decided to migrate SQL Server to a newer version? Would you like to test the load on the new SQL Server? How can you create a load ...
How to send TEXT when sql job fails.

I was wondering how to prioritize failure jobs. DBA gets tons of emails everyday and we don't want to keep checking out emails for faili...
Kill All Database Connections to a SQL Server Database

Everyday, when i have to refresh databases I have to run sp_who2 and see if there is any active connection to database. It's painful pro...
Rebuilding the master Database

The master database can be rebuilt using the Rebuild Master utility if: A current backup of master is not available. The backup cann...
SQL 2012 - SQL Server Distributed Replay

SQL Server Distributed Replay Benefits of Distributed Replay Similar to SQL Server Profiler, you can use Distributed Replay to replay...
Using Distributed Replay to load test your SQL Server–Part 2

After we have configured the Distributed Replay as explained in the previous post, we can use the Distributed Replay environment to create t...
SQL Server 2012 Express Edition Download Information

Express edition SQL Server Express is a free edition of SQL Server ideal for developing and powering desktop, web and small server applic...
Optimizing Tempdb Performance

The size and physical placement of the tempdb database can affect the performance of a system. tempdb Size and Placement Recommendations ...