Viewing 15 posts - 6,811 through 6,825 (of 9,253 total)
Its always been given bad press in the past due to the vulnerability. Its a feature hackers knew was there and could be exploited to harmful use.
I have an...
August 17, 2011 at 1:34 am
Have you configured the security for the mirroring session
August 16, 2011 at 4:31 pm
Have you configured the security for the mirroring session
August 16, 2011 at 4:30 pm
How are you configuring mirroring are you using scripts or the mirroring page on the database options?
August 16, 2011 at 4:09 pm
That's not entirely correct!
High Safety - High Availability and High Safety - High Protection modes will still allow connections to the database even when there is a mirror failure.
It's...
August 16, 2011 at 2:53 pm
The OS rebuild when adding a new CPU only affected Windows 2000.
2003 and 2008 should be fine just ensure the multi processor HAL is loaded 😉
August 16, 2011 at 1:47 pm
needed to see details of the configuration this morning not after you switched to asynch
August 16, 2011 at 12:07 pm
n.heyen (8/16/2011)
Currently only 12GB of RAM and only 2GHz on 1CPU allocated for SQL, just not enough.
I would of thought the RAM is ok, definitely ramp up the CPU to...
August 16, 2011 at 11:43 am
oops my bad, yes you need primary server too :blush:
August 16, 2011 at 11:40 am
please execute the following against the primary and post the results
select * from sys.database_mirroring
August 16, 2011 at 11:34 am
jpro1001 (8/16/2011)
and for the secondary server I would do this?exec sp_change_log_shipping_secondary_primary @database = 'MainDb',
@ file_retention_period = '8640'
😉
August 16, 2011 at 10:54 am
so are you running in High-Performance(asynchronous) or High-Protection(synchronous) mode?
August 16, 2011 at 10:46 am
DBAgal (8/16/2011)
since the documentation I've found is somewhat vague.
When running in High availability mode Books Online is quite clear and quotes the following
Books Online
August 16, 2011 at 10:40 am
have you verified that the new disk resources you intend to use for the new instance online and offline properly through the cluster management console?
Also check the new IP address...
August 16, 2011 at 10:30 am
jprovines (8/16/2011)
Is it safe to just manually update the backup_retention_period field?
That's exactly how you do it!
Use the following on the mirror\primary
exec sp_change_log_shipping_primary_database @database = 'YourDB',
@backup_retention_period = '8640'
Only change...
August 16, 2011 at 10:27 am
Viewing 15 posts - 6,811 through 6,825 (of 9,253 total)