SELECT *
FROM MSDB..RestoreHistory WITH (nolock)
WHERE destination_database_name = 'MyDB'
ORDER BY restore_date DESC
FROM MSDB..RestoreHistory WITH (nolock)
WHERE destination_database_name = 'MyDB'
ORDER BY restore_date DESC
Tuesday, 25 December 2012
Subscribe to:
Posts (Atom)
-
alter database current set single_user with rollback immediate ; go alter database current set multi_user ; go
-
Table Partitioning in SQL Server – Step by Step Partitioning in SQL Server task is divided into four steps: Create a File Group Add Files ... -
SELECT T.name AS [TABLE NAME], I.rows AS [ROWCOUNT] FROM sys.tables AS T INNER JOIN sys.sysindexes AS I ...