You should consider reindexing as per their fragmentation level. Its not a one which we simply decide to do. Please go through links provided by anthony.

Why cant you reindex daily? Cant you get maintenance windows for reindexing? Also are you do update stats on this table?

Can you check the sql error log and Sqlagent log and post them here to start troubleshooting.

High performance mode is available only in Enterprise edition.

Run this command in principal.

Alter database dbname set partner safety Off

See this link.

http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418

Can you do telnet virtual server name from passive node?

Can you tell telnet virtual server name from passive node?

Have you properly removed mirroring session before dropping mirrored database.

http://msdn.microsoft.com/en-us/library/ms190471(v=sql.110).aspx

Can you post the wait_type your select session is hanging on?

Try to use Net start to start the sqlserver with parameter -f and -m. Not sure this will work, but worth to try.

Did you check there is any session is blocking select query?

Automatic failover will happen. After this, application will be directed to new principal server(earlier it was mirrored) and will find only one database (in your case). Other two databases will...

Not sure why you are looking for script to edit port number.

You can use xp_regwrite SP to edit port number in registry keys. But its not recommended to edit reg...

shohelr2003 (11/27/2012)

---

Dear,

2. Now if I restore that backup files to Mirror, what would be that 1 hour updated transactions? Will I get those updated data after configuring mirroring?

Yes, But this...

"All this time i was thinking that if at any point sql needs more than 52 gb it would use page file".

Yes, SQL Server will "page out" some of the...