Viewing 15 posts - 6,091 through 6,105 (of 9,244 total)
peter Vramby (1/11/2012)
I have a clustered (active-passive) SQL Server cluster running under version 10.0.4000.0 (SQL 2008 SP2 64-bit Enterprise Edition) where the syspolicy_purge_history job is failing.
When I try to run...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 3:26 am
Dhirju (1/11/2012)
yes i have specified FQDNs, please see attachment..
do you have any firewalls between the nodes (Windows or otherwise)
Try a telnet to the port from the partner node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 3:24 am
Fully Qualified Domain Name, example below
my domain name is UKTrading.co.uk
my server name is SQLServer1
The FQDN for the server is SQLServer1.UKTrading.co.uk
To connect to this server in a mirror session using port...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 2:20 am
Dhirju (1/11/2012)
yes. but, when i m going to click on start mirror button then it is giving error.
even when you specify the FQDNs of the servers?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 2:09 am
laddu4700 (1/10/2012)
Here is the weird scenario
One of our client prod database functioning in client place (as per agreement). We don't have access to our own application database.
Now for bussines...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 1:58 am
Perry Whittle (1/11/2012)
you cannot specify IP address in the Mirroring wizard GUI
Specify the FQDNs of the servers in the mirror GUI and try again
have you successfully created the endpoints?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 1:54 am
Dhirju (1/11/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 1:47 am
kwilt1 (1/10/2012)
I was under the impression that Standby Mode wasn't a good option
What gave you that impression!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 1:22 am
Evil Kraig F (1/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2012 at 5:08 pm
*yawn* now we've all finished slagging off MS, their products and their Gold partners can we move onto something else. A lot of the people in this thread doubtless earn...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2012 at 4:30 pm
when the database is in full recovery model and you delete a log file, it will still list in sys.database_files and sys.master_files.
You must take a transaction log backup and the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2012 at 4:03 pm
what is the recovery model of your database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2012 at 2:56 pm
make you sure you get all the pre reqs in place as SQL Server 2008 requires a handful of hotfixes etc to install before installing SQL Server itself.
Any reason why...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2012 at 11:32 am
san43 (1/10/2012)
What is IPAll in TCP/IP properties protocol tab?
it is the port that sql server would listen on for all IPs assigned to the server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2012 at 11:30 am
Get SQLIO out and push the storage to see what you can and cant get out of it. this forms the base of what you can provide performance wise
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2012 at 11:29 am
Viewing 15 posts - 6,091 through 6,105 (of 9,244 total)