The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005 database in recovery Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments To enable database mirroring for evaluation purposes use trace flag 1400 during startup backup sql database Sql Server Mirroring Connection Pooling Linq to Sql ASp.net 2.0 step by step Membership Provider Where is my IP location MS SQL server 2005 attach databse without ldf file ms sql slow MS SQL server mirroring remove end points master key asp net image upload cliconfg Cut Is Faster Than Copy Paste Asp.net Interview Questions for 2 years or 3 years experiance Connection Pooling Explained Keyword not supported data base Linq-to-SQL-Insert-syntex Web Hosting Providers Could not allocate space for object dboSORT temporary run storage MS SQL server shutdown Linq Inner Join sql server agent backup Membership Provider Linq to SQL

database in recovery

If database suddenly went in to in recovery mode, due to less available space for transaction, you can fire below query and bring it live

USE master
GO
ALTER DATABASE pubs
SET QUOTED_IDENTIFIER ON, RECOVERY FULL, MULTI_USER

Simple Recovery
Simple Recovery allows the database to be recovered to the most recent backup.

Full Recovery
Full Recovery allows the database to be recovered to the point of failure.
Bulk-Logged Recovery
Bulk-Logged Recovery allows bulk-logged operations.

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

RESTORE cannot operate on database because it is configured for database mirroring Use ALTER DATABASE to remove mirroring if you intend to restore the database ALTER DATABASE YOur_Database_Name SET PARTNER OFF Now, to remove mirroring you can execute RESTORE DATABASE YOur_Database_Name &n...The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005 The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005. If you are trying to shrink dat...Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments To enable database mirroring for evaluation purposes use trace flag 1400 during startup You need to install SP2 for MS SQL server 2005 Link to download SP2 http://www.microsoft.com/downloads/details.aspx?FamilyId=D07219B2-1E23-49C8-8...backup sql database In this post, I will explain scenarios of taking backup of entire SQL server data bases and restorng it on other servers. You&n...Sql Server Mirroring SQL server mirroring works based on principal of Transaction log shipping. Alan, has published this tutorial is for people who are really really frust...Connection Pooling Hi, my name is Satalaj. Here, I'm going to explain what is connection pool with solid proof. Connection pool as name suggest its ...Linq to SqlIn this article we will see how to fetch data from any database and query using Linq syntexASp.net 2.0 step by step Membership Provider ASP.Net Membership provder step by step. Create user, Add user into Role, Authorize user, Redirect user to login. Password recovery control,asp.net membership ...

Comments

11/30/2010 6:11:01 AM #

This is such a deep blog! What can I say, youve hit the nail right on the head! You even added some videos to make it seem so much more real. Youve got a great way of communicating with the reader, a great way of making me feel like what you have to say is just as important to me as it is to you. Keep it up!

Window cleaning Wellington

12/2/2010 6:14:09 AM #

Im not going to say what everyone else has already said, but I do want to comment on your knowledge of the topic. Youre truly well-informed. I cant believe how much of this I just wasnt aware of. Thank you for bringing more information to this topic for me. Im truly grateful and really impressed.

pmp certification training

12/3/2010 5:11:09 PM #

Wow, what a blog! I mean, you just have so much guts to go ahead and tell it like it is. Youre what blogging needs, an open minded superhero who isnt afraid to tell it like it is. This is definitely something people need to be up on. Good luck in the future, man.

magic tricks

12/4/2010 5:05:00 AM #

I must say that overall I am really impressed with this blog.It is easy to see that you are passionate about your writing. If only I had your writing ability I look forward to more updates and will be returning.

Fisher-Price Smart Cycle Racer

12/6/2010 9:53:28 AM #

Hi. this is kind of an -unconventional- question , but have other visitors asked you how get the menu bar to look like you've got it? I also have a blog and am really looking to alter around the theme, however am scared to death to mess with it for fear of the search engines punishing me. I am very new to all of this ...so i am just not positive exactly how to try to to it all yet. I'll just keep working on it one day at a time.

Internet marketing

12/6/2010 11:35:06 PM #

Valuable information and excellent design you got here! I would like to thank you for sharing your thoughts and time into the stuff you post!! Thumbs up

portland web design services

12/8/2010 5:11:31 AM #

Im no expert, but I think you just made the best point. You obviously know a lot about what youre talking about, and I can really get behind that. Thanks for being so upfront and so honest about the subject matter. I really feel like I have a better understanding now.

pulse oximeter

12/8/2010 10:57:11 AM #

Can I just say what a relief to find someone who actually knows what theyre talking about on the internet. You definitely know how to bring an issue to light and make it important. More people need to read this and understand this side of the story. I cant believe youre not more popular because you definitely have the gift.

8-Tab

database in recovery

Related posts

Comments

RecentPosts

Page List

Author

database in recovery

Related posts

Comments

RecentPosts

Page List

Author

Subscribe / UnSubscribe Email list

Thank you