Viewing 15 posts - 1 through 15 (of 1,068 total)
Thanks windows_mss
Your reply helped me.
November 9, 2016 at 3:20 am
Alan Naylor (3/17/2014)
I ran the below query and I got 17GB of data. Why is the database 290 GB.
I think large tables are purged and that space is not yet...
March 18, 2014 at 3:18 am
I was also confused by this initially.
When the database is in stand by mode, primary database's path\filename is returned.
Correct path\filename is shown when the secondary database is made online.
March 18, 2014 at 3:13 am
Do these two databases already exist in the secondary server?
If yes, check whether any users are using these databases.
March 5, 2014 at 2:12 am
Both of you are right.
sp_validatelogins doesn't list the logins that have been DISABLED in AD.
It only lists the loigns that are DELETED in AD.
February 1, 2014 at 1:42 am
Subrata Bauri (1/31/2014)
January 31, 2014 at 5:09 am
Yes, these are SQL Agent jobs. Job name would be similar to the publication name.
Log-Reader job runs on the Publisher. Distribution Agent jobs run on the Distributor (on Subscriber if...
January 29, 2014 at 8:39 am
Right click on the subscription and select "View synchronization status"
Make sure that Log-Reader and Distribution Agent jobs are running.
January 29, 2014 at 2:17 am
The reason is, that user is not the owner of the job or not member of sysadmin server role.
Just SQLAgentOperatorRole membership is not enough to edit/modify a job.
Only job...
January 8, 2014 at 5:52 pm
SQLAgentOperatorRole members change edit/modify "owned" jobs only.
January 8, 2014 at 5:35 pm
Robert klimes (1/8/2014)
Has anyone seen this or have any suggestions outside of restarting the instance (last resort) on how to stop it from logging.
I have seen this. Please check...
January 8, 2014 at 9:13 am
The other db has more free spaces. This is expected behaviour. DB size is not same as size of objects.
January 8, 2014 at 9:06 am
erp.cncjay (1/7/2014)
Question: Is it even possible to add records to the subscriber that is NOT coming from the publisher ?
Yes. It is possible to add records to subscriber directly.
Even delete...
January 8, 2014 at 8:56 am
ramana3327 (1/7/2014)
...but still SQL server is not utilizing the available memory.
This is the expected behaviour of SQL Server. It won't utilize memory unnecessarily.
Memory utilization depends on load.
January 8, 2014 at 8:43 am
naidu6 (9/23/2013)
i am getting error that ACESS IS DENIED.
Open the command prompt Windows with Admin previleges.
Right click on Command Promopt -> Run as Administrator
September 24, 2013 at 3:38 am
Viewing 15 posts - 1 through 15 (of 1,068 total)