Geeks With Blogs

News


Search this Blog via
Google Search This Blog


Kit Ong's News Pick Of The Day All things .NET, SharePoint and Latest Technology News

This is a strangest error I have come across whilst working with SharePoint 2010, the full error is this.

[12/20/2011 5:29:10 PM] Warning: [WSS_Content] The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.

RESTORE DATABASE is terminating abnormally.

The error message was written to the file restore.log found in the SharePoint backup folder, it seems that the following keyword in TSQL caused the error.

IF EXISTS ( SELECT * FROM master..sysdatabases WHERE has_dbaccess(name)=1 AND name=@db_name )
BEGIN
    SELECT 1 as ErrorCode
END
ELSE
BEGIN RESTORE DATABASE [WSS_Content] FROM
DISK=@db_location WITH STATS=5, FILE=1, MOVE @db_OldName TO @db_NewFile, MOVE @db_OldLogName TO @db_NewLogFile, NOREWIND, NOUNLOAD, RESTART, RECOVERY
END

The combination of software I had installed was SharePoint 2010 Service Pack 1 with SQL Server 2008 R2

 

Resolution

To fix this error I took the drastic action of downgrading SQL Server to 2008 R1, the keyword RESTART no longer appears when I restore the SharePoint Farm. This problem could also be down to SP1 issues.

 

Posted on Tuesday, December 20, 2011 10:18 PM Windows Server 2008 , SharePoint 2010 | Back to top


Comments on this post: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
Wow, this issue is really what I've looked for since this morning. Thank you've saved my time. Jasaseo.
Left by Helena Smith on Aug 15, 2015 4:36 AM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
Never thought such issue before, yet now I knew it well. Thanks for the author. la quinta real estate.
Left by Kimberly on Aug 18, 2015 6:39 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
It takes a few second to browse this page. Your web is very fast. More over, your content is also great. palm springs wedding venue.
Left by Lisa Phillian on Aug 21, 2015 1:54 AM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
The shiny surface and round shape make these sterling silver beads ideal for creating necklaces, bracelets, anklets, earrings and more.
Left by SSB on Sep 08, 2015 7:37 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
A great solution for this fix though downgrading SQL Server to 2008 R1 may not entirely appeal to many much as the keyword RESTART no longer appears when you restore the SharePoint Farm....
Corporate Catering Buffet Caterers Stockport, Cheshire
Left by mike dean on Jan 06, 2016 6:30 AM

# Independent Bangalore Escorts
Requesting Gravatar...
Its interesting topic, we can know about code visibility, Thanks for share with us.

Left by Pyari Anaya on Aug 18, 2016 5:44 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
Its interesting topic, we can know about code visibility, Thanks for that and keep sharing.
Female Bangalore Call Girls

Chandigarh Escorts in Girls
Left by Sapna on Aug 18, 2016 5:46 PM

# woow
Requesting Gravatar...
Sure, it’s a good thing to enjoy your work, but there is such a thing as enjoying it too much.
bejeweled
tank trouble
Left by tank trouble on Dec 07, 2016 2:13 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
Today I learned a lot from your website. thank you
Thank you for sharing the information very useful. It is very pleasant to read this article from your website.
waiting for next article, so interesting. OBAT BATUK
Left by sasa on Dec 16, 2016 7:09 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...

Wow. cool post. I’d like to write like this too – taking time and real hard work to make a great article… but I put things off too much and never seem to get started. Thanks though.
super smash flash 2
bloons tower defense 5
Left by MarkCPhillips on Dec 25, 2016 8:24 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
you r right Mark, it takes a lot of hard work to write articles.
HP Printer Support
Lexmark Printer Support
Left by kaitlyn june on Jan 08, 2017 11:16 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
Left by Spysoftware on Jan 16, 2017 8:49 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
Left by Epson Customer Support on Feb 04, 2017 6:35 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
Today I learned a lot from your website. thank you
OBAT HERNIA
Left by sasa on Feb 10, 2017 3:54 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
Today I learned a lot from your website. thank you
apakah Anda sedang mencari Ramuan Obat Hernia Ampuh Alami Mengatasi Turun Berok ? saya akan memberikan kepada Anda Informasi mengenai Obat Hernia atau Tedun (Turun Berok) Secara Tradisional Alami
Left by sasa on Feb 14, 2017 3:34 PM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
Thank you for sharing in this article. I can learn a lot and could also be a reference. I hope to read the next your article updates.
Shaki Pramuka
Grosir Perlengkapan Pramuka
Left by Shaki Pramuka on Feb 24, 2017 8:45 AM

# re: The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
Requesting Gravatar...
This is nice and informative post. Thanks for sharing. Bitdefender Total Security 2017 keygen
Left by Priya Rani on May 09, 2017 3:31 PM

Your comment:
 (will show your gravatar)


Copyright © Kit Ong | Powered by: GeeksWithBlogs.net