This error usually occurs when the account passowrd is updated recently. Update the SQL service account passowrd and cycle the SQL services....
Open the cluadmin and open the connection using any of the node.
In SQL group,under the SQL Network Name and SQL Ip address, the SQL virtual...
On secondary server, at some point of time, Restore of the T-log file fails because of the following error:
I/O error 38(Reached the end of the...
In Yukon, if we check the event viewer, it is showing me the following error:
"Unable to read local eventlog(Parameter is incorrect)"
I am performing a replication of pull subscription from X(publisher) to Y server(subscriber) via Z(distributor). Y server is very slow in...
I am getting error from replication:
"The row was not found at the Subscriber when applying the replicated command."
What is this mean and why...
I checked everything its fine..
I have a doubt how to add a login to a "security access" --> "Through Group membership ".
I found my login...
When I tried to connect to QA analyzer using my login, I was being alerted by following error message:
"Logon Failure: unknown username or...
I need to rename the instance name for sql server.
Suppose if the old SQL servername is abcx , I need to rename to abcy.
How it can be...
Even when I tried to remove the database, it is showing the message "Cannot be removed ..the database is in use".
So I recycled the sql...
sp_spaceused , is used to give only details about the datafile and log file size used and unused.
Please note I need only which table in...
suppose if we found that the datafile was full for a database, in that case how to find the which table consumes more space in a databse ..Is...
Suppose if we take a cluster..
We will be having a quorum resource in a cluster ..right.. when we want to that this sql resource
is running under...
I want to know who owns(owner) the quorum resource for a cluster?..
For exapmle, if we say sql server we can find out it is running at this...
I am performing log shipping.when I am trying to restore a database on secondary server
by replace option, if found that the database is in...
Suppose total RAm Memory in a server is 16GB.
In that ,SQLserver is configured with max memory of 15 GB leaving aside 1 GB for OS.(
Please help me in this situation.I have two questions.
1) have total RAM size of 16GB. In that I have set 15GB for SQL server..
Thanks a lot for your explaination.
How locking is different from blocking. Whether locking is done automatically.
I need some details regarding blocking..
What is blocking and what usually causes the blocking with more definition..
How the blocking can...
This stack dump would be created when there is a log-shipping while restoring T-log job was running on the secondary server.. This would...
Separate names with a comma.