Viewing 15 posts - 4,351 through 4,365 (of 9,244 total)
Is the SQL Server agent service running?
Open Failover Cluster manager and check the clustered service resource is healthy
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2013 at 9:16 am
SQLCrazyCertified (1/29/2013)
Hi, Thanks for both of your replies.I have fixed the issue by doing couple of more log backups then I shrank and it worked.
You have cycled the log back...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2013 at 9:15 am
sdpages (1/29/2013)
I have a SQL log-shipping High availability setup from a Primary Server to a Secondary Server which ships transactional logs every 1 hour. Both the databases are running...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2013 at 9:11 am
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
Viewing 15 posts - 4,351 through 4,365 (of 9,244 total)