Viewing 15 posts - 541 through 555 (of 1,536 total)
Some great information on this can be found at this link
December 30, 2008 at 1:26 pm
Let's be fair, the max and min might not be the same.
It's not like anything else on the server is going to ask for memory, so it's just going to...
December 30, 2008 at 1:02 pm
I call shenanigans on the vendor.
Doesn't matter where the files or filegroups exist on the server.
A backup/restore is totally valid.
December 30, 2008 at 12:24 pm
Are you keeping the extracts from the previous day? Possibly manipulating the extracts and moving them into another table, thus causing the growth?
Bear in mind that the space will...
December 30, 2008 at 7:51 am
Have you tried pinging the virtual server name that you are attempting to use? Check to see if it's live and valid? If so you might want to look around...
December 30, 2008 at 7:06 am
You are specifying a remote login which is a sql account, you state that this is your domain account, this won't work.
Given the method you are attempting to use you...
December 30, 2008 at 7:02 am
First thing, just try deleting any log using a delete against the view and passing the job name and the < date, see if that works. If there are no...
December 30, 2008 at 6:23 am
Firstly split two of the instances off to the passive node, why waste all those resources? That way you can tweak the memory upwards on the others.
Start there and see...
December 29, 2008 at 7:24 pm
See, if only I could read logs.... :blink:
I would definitely check the 2005 instance, sounds like there might be an issue there.
If you are going to set static ports it...
December 29, 2008 at 6:52 pm
Also check the "HideInstance" option within the network configuration stuff, that prevents SQL Browser from returning any information about the ports that SQL is listening on.
December 29, 2008 at 2:43 pm
UDP appears to be listening on 1596 (correct me if I am reading this wrong)
sqlbrowser.exe:1596 UDP
This should be...
December 29, 2008 at 2:38 pm
Did you check what ports that the 2005 server was listening on? Check and see if there are rules allowing traffic through on those particular ports.
You might also want to...
December 29, 2008 at 2:15 pm
IF you're on a cluster the cluster logs themselves are an immense help in these kinds of situations.
December 29, 2008 at 1:13 pm
You can't.
You would have to reinstall SQL 2005 from scratch and bring it up to the previous level and restore your databases from a backup.
December 29, 2008 at 12:58 pm
Completely opening the firewall is dangerous you could potentially be at risk from a security standpoint.
Have you tried changing the 2008 instance to listen on 1433 instead of a dynamic...
December 29, 2008 at 12:52 pm
Viewing 15 posts - 541 through 555 (of 1,536 total)