Viewing 15 posts - 3,376 through 3,390 (of 6,679 total)
gchaimovitz (2/16/2011)
February 16, 2011 at 4:17 pm
THE-FHA (2/16/2011)
so what you must do is deleted the services as follows:-
ON THE COMMAND PROMPT RUN THESE COMMANDS.
sc delete MSSQLSERVER
run sc delete commdand for all...
February 16, 2011 at 4:11 pm
What your process ran into is a deadlock. When SQL Server sees a deadlock happen, it chooses one of the processes as the deadlock victim and terminates it.
A deadlock...
February 16, 2011 at 4:04 pm
SQLJocky (2/16/2011)
Yeah, the crazy thing is that it is both domain admin and is explicitly added to the share. 🙁
From your original post - it sounded like your service account...
February 16, 2011 at 3:14 pm
If you have no issues connecting with the name inside the network, then you have a firewall issue on the VPN. Either port 1434 is blocked or that instances...
February 15, 2011 at 7:31 pm
Lowell (2/15/2011)
February 15, 2011 at 2:08 pm
You cannot restore system databases from a different edition. You will need to script out the agent jobs, logins, etc...
You can download and use the sp_help_revlogin procedure to move...
February 15, 2011 at 2:04 pm
If the instance is on a cluster, that instance should have its own resource group which has a defined IP address and name. The cluster handles redirecting the request...
February 15, 2011 at 1:57 pm
I would failover any active resources on that node to a different node, restart the node and fail the resources back. This will cause an outage for the system...
February 14, 2011 at 7:52 pm
Are you logging of an RDP session to the server where the restore is running? If not, why do you have to log back in?
Check your terminal services configuration...
February 14, 2011 at 7:48 pm
Meet George Jetson (2/14/2011)
Even though Statistics are updated by the query optimizer, it is not a bad idea after a Index rebuild to run UPDATE STATISTICS
Actually, that is just a...
February 14, 2011 at 1:51 pm
If this is not a maintenance task - then you really shouldn't put it in a maintenance plan. You should just setup an agent job and run it from...
February 14, 2011 at 1:22 pm
No, there is nothing in Litespeed that would do that - as far as I know.
February 14, 2011 at 1:14 pm
First - what do you mean by SQL Server shuts down? Performing a restore of a database will not cause SQL Server to shut down.
Second, what is the command...
February 13, 2011 at 6:24 pm
Do you have multiple SQL Server instances - one for SQL1 and one for SQL2? Or, do you have a single instance of SQL Server with two databases?
If the...
February 13, 2011 at 6:17 pm
Viewing 15 posts - 3,376 through 3,390 (of 6,679 total)