Viewing 15 posts - 4,141 through 4,155 (of 9,244 total)
Jeffrey Williams 3188 (4/29/2013)
switch recovery model back to full - take a full backup - and restart your transaction log backups.
Taking a diff backup instead of a full maybe quicker...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2013 at 8:15 pm
Surely you mean 😉
Steve JP (4/27/2013)
1)switch to simple recovery2)backup database
3)checkpoint database
4)shrink log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 7:27 am
You can apply an SP and CU when slipstreaming an install, but the PCUSource and CUSource parameters do not apply to straight SP or CU installs.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 7:22 am
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
Viewing 15 posts - 4,141 through 4,155 (of 9,244 total)