Viewing 15 posts - 5,266 through 5,280 (of 9,244 total)
rummings (7/23/2012)
I read that to use "Always On"... you need to run SQL Server 2012 Enterprise Edition. We were considering going to three Virtual Servers for the new cluster.
yes AO...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 3:02 pm
farushaik (7/23/2012)
Anthony,I was following that process. But the database doesn't change to single user mode for some reason.
I think I'll have to go for restoring from the backup ..
see my...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 7:26 am
farushaik (7/23/2012)
Table error: Object ID 706101556, index ID 2, partition ID 72057597246242816, alloc unit ID 72057597500653568 (type In-row data), page (38175:9). The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 7:25 am
SQLCrazyCertified (7/23/2012)
So, I would say best practice is to stop/start SQL from Configuration Manager.
Or failover cluster manager if it's a clustered instance of SQL Server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 7:18 am
Ferguson (7/23/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 7:16 am
Most SAN\NAS technologies will allow you to mask off LUNs from one host and attach to another. However, it may be better to mirror the current LUNs to new LUNs...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 7:09 am
Stamey (7/23/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 6:12 am
the only concurrency issue you're likely to get is if someone is updating the table at the time you request the reads
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 6:09 am
Just seen this post but need to clarify.
There is a difference between the user\schema dbo and the database role Db_Owner.
A user who is the owner of a database will map...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 5:59 am
santosh.balaraj (7/23/2012)
I am writing a program to restore a Database which is part of a AAG group.
What are you trying to restore, the primary or a replica database?
santosh.balaraj (7/23/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 5:46 am
there's not a lot we can do without the error messages, please provide them as Anthony has advised
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 5:43 am
thunderousity (7/23/2012)
I was reading it incorrectly.
Thanks I'll set it and monitor it.
Will 64bit SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2012 at 3:58 am
Yes so it does. Apologies for that, been a long day
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2012 at 3:10 pm
http://www.sqlservercentral.com/articles/Database+Mirroring/72294/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2012 at 7:35 am
You don't need to break mirroring at all. Pause the mirror and then perform a backup on principal and restore with move to mirror then resume mirroring. It's all in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2012 at 6:31 am
Viewing 15 posts - 5,266 through 5,280 (of 9,244 total)