Viewing 15 posts - 5,266 through 5,280 (of 9,241 total)
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
You should only run checkdb once with data_purity on a pre 2005 database to invoke the flag, this is not necessary on 2005 on as the checks are automatically completed.
Try...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2012 at 1:17 am
Has this database ever produced a clean CHECKDB result?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2012 at 10:36 am
dbasql79 (7/20/2012)
Hi Folks,1. Can Multisite clustering work on single node per site? Like Node1 on Site A and Node2 on SiteB provided SAN replication.
Yes it can.
dbasql79 (7/20/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2012 at 10:21 am
Viewing 15 posts - 5,266 through 5,280 (of 9,241 total)