Viewing 15 posts - 4,141 through 4,155 (of 9,241 total)
george sibbald (4/27/2013)
could you expand on that perry?
You run setup with the skip validation rules parameter. Search google you'll find it.
I generally wouldn't recommend it though as using skip...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 7:19 am
AllenValk66 (4/26/2013)
the temporary table should be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 12:58 am
zi (4/26/2013)
(you may have to run a checkpoint or two before the log rolls over to the free space to allow shrinking) will work,how to run a checkpoint?
Thanks
use [yourdb]
GO
checkpoint
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 12:40 am
Larry Kruse (4/24/2013)
Node01 = runs an instance of Report Services pointing at a production report services database on the cluster.
Node02...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 12:36 am
something i've never tried actually, but i would follow this
dan-572483 (4/25/2013)
2) Failover
3) Install SP on the other node.
4) Failover
5) Install CU on the 1st...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 12:29 am
A user maps to dbo when they are the owner of the database. Open the database properties and check\change the account who owns it.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 12:24 am
Have you created a database mirroring endpoint on the witness and granted the appropriate account connect permission?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 12:21 am
Use the appropriate escape macro, if you dont need to escape any quote marks then the following will apply
INSERT INTO dbo.[DB Mirroring State Changes] (
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 12:19 am
You could check the history tables see if they have recent events logged
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2013 at 10:44 am
mJai (4/26/2013)
Anything else?
Yes enable service broker on the database, it's detailed in books online.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2013 at 1:03 am
You had service broker enabled before, you'll need to re enable it again. Ideally you should restoring your current backups of your system databases to retrieve the previous configuration.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2013 at 9:15 pm
Firstly I would start with the ESX hosts, check the HBA types and settings
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2013 at 8:58 am
sql-lover (4/24/2013)
It has been very difficult to explain and support my arguments though. I've been questioned a lot (knowing this by experience) and it is really FRUSTRATING! 🙁
point them to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 2:41 pm
sql-lover (4/24/2013)
The MCS policy was set to "round robin".
You use either MPIO or MCS not both, so, are you using MCS or MPIO?
MCS is specific to the Microsoft iSCSI Initiator...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 2:21 pm
sql-lover (4/23/2013)
Hi Perry,The shared storage is a Dell Compellent SC8000 SAN, connected via iSCSI / MPIO to both nodes. The Windows Cluster runs on Win2008R2 SP1. MS-SQL runs SQL2012 Standard.
I'm...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 10:47 am
Viewing 15 posts - 4,141 through 4,155 (of 9,241 total)