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...
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...
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...
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..
I need some details regarding blocking..
What is blocking and what usually causes the blocking with more definition..
How the blocking can...
Could you please us in this issue.
I sit possible to move the table in a database from one filegroup to another filegroup.
If so, Please...
Let me know how to find database name using the datafile and log file using query ...
Pl.help me out if you do have any sp or scripts,so...
If we are replicating a database from primary server to another server named test...whether the database that is copied would contain all...
What to do when Log file of a user database becomes full.
Pl.Let me know the diff. b/w the xtended and simple stored procedure
How to create a system function?
Is there any way?
If I copied one *.dts package thru mail and when I am trying to open that package by DTS in Enterprise manager, I am getting some error as
Suppose if we r creating a cursor and opening it..
where those records of that cursors will be stored for performing some operations.
Separate names with a comma.