Backup\ Restore completion Status.

Question

Post reply

Backup\ Restore completion Status.

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

deepak.a SSCertifiable Points: 5330 More actions · Answer 1

deepak.a

SSCertifiable

Points: 5330

May 19, 2010 at 11:06 pm

#1169866

Thanks vk-kirov

For the Example 🙂

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Nice question.

Thanks

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 3

Thanks Jason and everyone for putting up your valuable suggestion and comments. Many Thanx. Might be the question looked a little confusing due to the keywords which I used (E.g, table in place DMV), well, I am pretty good to see our experts are not only experts infact they are indeed a good MENTOR.

I am pleased to see that my question has been published.

Moreover, your postive feedback always help me to put up new questions and make me encourage to clarify the doubts of the other users.

Thanks.. Thanks & Thanks@!!

Thanks.

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 4

vk-kirov (5/19/2010)
Kari Suresh (5/19/2010)
where and how we can use this? Anybody can explain with an example?
For example, it may be very useful when a big transaction rolls back and you want to know the progress status of the rollback.
Here is a simple example. First of all, let's create a table and fill it with the data (it took 5 minutes on my local machine, and 1800 MB on the hard drive (800 MB for the data file and 1000 MB for the log file)).
SET NOCOUNT ON
GO
CREATE TABLE RollbackTest (a CHAR(8000))
GO
BEGIN TRANSACTION
GO
INSERT RollbackTest VALUES ('test')
GO 100000
Here we have a huge uncommitted transaction. Let's roll it back (it took 6 minutes on my local machine):
ROLLBACK TRANSACTION
We can monitor the rollback progress in another window:
SELECT percent_complete, *
FROM sys.dm_exec_requests
WHERE session_id = <spid of the rollback process>
Also we can monitor the progress of backups/restores/etc.
Of course, we can't see the execution progress of queries (such as SELECT/INSERT/UPDATE/etc).

Very Nice explanation. Answered alot of questions and confusions.

And Very informative QOTD Saurov. Thanks.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

TomThomson SSC Guru Points: 104773 More actions · Answer 5

Nice question (I saw it after the change from "table"). Nice example from vk_kirov made it clear how it can be used.

Tom