Hi..

We are using SCOM 2007 to monitor SQL Server 2008 instances. I have checked the blocked sessions alert details in SCOM console as well as in OperationsManager database. I was...

Check the below articles to resolve the below messages in sql error log.. Basically add -T845 flag in sql server startup parameter and sql service account should have lock pages...

I think I have another option here without touching the publication database ...

1. Stop the application (to ensure that no more data added to table)

2. Take full backup of mydb...

Thank You ... & Wish You Happy New Year !!

I have tried to create an account (Qmunity), still I am unable to access the link you have provided. Can I...

@ Ewan Hampson

Yes I meant 9.00.3042. We have already planned to apply Service Pack 4 on all the SQL Server 2005 instances.

@ george sibbald

I have not received the files you...

Hi...

I did not have another instance of SQL Server. So I have installed named instance and copied the data & log files of model database. Started the default instance of...

I have tried another option using the tempdb data and log files as per the link (http://www.sqlservercentral.com/Forums/Topic1054581-1550-1.aspx). I am unable to start the sql service, getting the below...

Hi...

Yes. I have copied the correct .ldf file back to original location. I do not have another instance of sql server on the box.

I have tried to start the sql...

Hi ..

Thanks.

I am not sure how to restore the model database here. I am unable to start the sql server in single user mode. Do i need to uninstall and...

Hi,

I have the good full backup of system databases and user databases.

This is what happened...

1. By mistake moved the log file of model database to another drive when the sql...

Hi All,

I am trying to get the details of new databases created on a weekly basis. My Multiserver connection manager is not working, throwing the below error.

Test Connection failed because...