Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How do I stop restore which I am doing using SQL Litespeed, Urgent please!!


How do I stop restore which I am doing using SQL Litespeed, Urgent please!!

Author
Message
Mh-397891
Mh-397891
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 1514
I am using SQL Litespeed tool for the restore of a database backup, can someone let me know how I can stop the restore as it looks like the restore is hung, Thanks!!
TheRedneckDBA
TheRedneckDBA
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1876 Visits: 2592
I'm not familiar with Litespeed.

Does it use some sort of extended stored procedure, or does it run as a standalone program?

Assuming you know your backup is good, can you use task manager to manualyl kill litespeed and/or bounce SQL services to free it up?

The Redneck DBA
Mh-397891
Mh-397891
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 1514
It runs based on extended stored procs, without bounvcing the sql services can we stop the process? Thx.
TheRedneckDBA
TheRedneckDBA
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1876 Visits: 2592
Not being a LiteSpeed guru I hesitate to suggest much. I'd look on Quest's support page. It may be a common problem with a simple solution.

Another thing you might do is look thru the Windows event logs. I used to use Idera SQL Safe, and sometimes errors would get logged there and nowhere else.

The Redneck DBA
Linda-272642
Linda-272642
SSC Journeyman
SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)

Group: General Forum Members
Points: 80 Visits: 110
Is it using a connection to sql server. If so you can find out the spid by doing a sp_who2 and dbcc inputbuffer and kill the spid. I also am not familiar with litespeed but I would start there.
Vivien Xing
Vivien Xing
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1294 Visits: 2204
Litespeed backup is compressed. When the backup is restored, it will be decompressed first then restored. Depends on the database size, it may take a while for the whole process. During the decompressing period, you will see the process is doing nothing (hanging).

You may terminate it by killing the process.
Mohan Kumar
Mohan  Kumar
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1341 Visits: 596
I think you will not be able to stop without stopping sql service. you may try killing process id using tskill command thru DOS Command prompt

--www.sqlvillage.com
David Swanson
David Swanson
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 45
Hi MH,

I'm sorry you're having trouble with your restore. You can stop a hangin restore restore by either killing the spid that LiteSpeed is using or by ending the LiteSpeed process (sqllitespeed32.exe). You will not have to stop the SQL Server process at any point in time.

You can then restart the restore and if the problem persists you should contact Quest support. LiteSpeed is supported 24/7 and they'll be happy to help you.

Regards,

David Swanson
Quest Product Management
Vivien Xing
Vivien Xing
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1294 Visits: 2204
I remember there is a parameter showing the restore progress, like 10% something, when using xp_restore_database. I did not see it work when I used it.

David, do you know anything about this? Do you have an example to share how to use this parameter to see the restore progress?

Thanks,
Vivien
David Swanson
David Swanson
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 45
Hi Vivien,

The parameter is " @with = 'STATS = 10' ". Change the '10' to whatever oncrement you want reported. The progress var in the interface defaults to 10%.

I hope that helps.

-David
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search