Viewing 15 posts - 4,351 through 4,365 (of 9,241 total)
SQLCrazyCertified (1/28/2013)
I have a db with mirroing in place and log is growing about 49GB.....Log is growing since log backup not running as it scheduled. So, I manually...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2013 at 4:07 am
anthony.green (1/29/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2013 at 4:03 am
anthony.green (1/28/2013)
A page is allocated to a table
or an index 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2013 at 2:25 am
OPC is correct, XP_FIXEDDRIVES cannot enumerate mounted volumes. A straight WMI call will also work using
wmic volume get capacity, "free space", name
You can also supply an output file and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2013 at 2:24 am
I wasnt being sarcastic i'm genuinely surprised!
you're right, i dont think theres a good reason, AO replaces log shipping and mirroring and pretty much makes them redundant 😉
Leo.Miller (1/24/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2013 at 11:35 pm
Shouldn't you be actually gaining the required knowledge rather than brain dumping a few answers. No doubt if you do manage to land the role any support you require will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2013 at 5:10 am
Niyala (1/25/2013)
I can evict one and install the other widnows cluster.
No! Don't just evict the nodes.
Niyala (1/25/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2013 at 7:47 am
More importantly are they differing versions of the Windows OS
What OS are the current nodes?
What OS are the new nodes to be?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2013 at 6:45 am
The following when executed against the LS primary databases instance will return configuration info
exec sp_help_log_shipping_primary_database 'primaryLSdb'
The following when executed against the LS secondary databases instance will return configuration info
exec sp_help_log_shipping_secondary_database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2013 at 6:43 am
ipgsql (1/24/2013)
Looking for some opinions/links. If a SQL server (OLTP) is restricted to a single box with max 8 drives, would four RAID1 arrays (OS,TEMPDB,LOGS,DATA) be the way to go?
Or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2013 at 2:58 am
Posting your issue once only and in the correct forum will yield you better results!!
All replies here http://www.sqlservercentral.com/Forums/Topic1411479-1549-1.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2013 at 2:19 am
Gijs Laandrecht (1/24/2013)
I just can't figure out WHY should I configure the Always On feature when the SQL-server is in a Failover Cluster already?
The AO nodes must be part of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2013 at 2:15 am
siddiquiakmal (1/24/2013)
Call sp_define_log_shipping_monitor with @delete_existing=1...
Have you tried removing the LS monitor as detailed above?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2013 at 2:02 am
Leo.Miller (1/24/2013)
There is a difference between High Availablity and Disaster Recovery.
No! Really, you think?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2013 at 1:57 am
Is this a VMWare ESX farm or some other hypervisor?
Which version of the hypervisor are you using?
Are the virtual machines disks all virtual disk files or are you using Raw...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2013 at 1:55 am
Viewing 15 posts - 4,351 through 4,365 (of 9,241 total)