Hi,

I think you are talking about the jobs which get created automatically when you configure the log shipping. If this is the case, when ever you configure the log shipping...

Hi Duran,

It is always recommended to put the data & log files on separate drives. Usually we put data file on RAID 5 or RAID 1, and log file on...

Recovery model of the database is Full.

However as per the result shown by DBCC LOG, log file doesn't contain any entry for hostname corresponding to the entry "Truncate Table"...

Hi Stupeo,

Does this provide the same information as DBCC LOG does ? I have checked the DBCC LOG & does not contain any hostname entry. Adding a trigger will not...

Hi,

I think most of the DBAs are already having this kind of everyday checklist. The point is, we need the automation of it. Its literaly annoying to do these tasks...

Hi,

I faced a similar situation when I need to get the list of all the tables with the index on them. I had to show null for the those tables...

Hi Rajat,

You shoukd go with stand by mode because it allows you to read the data from secondary server. TUF files are Transaction Undo Files. These files contain the uncomitted...

Hey Win,

So were you able to start the sql server agent ?

I think this could be one of the reason that you are not able to start the sql server agent. Because every timne SQL Server agent starts it writes the...

Win,

Did you try rebooting the system? Because normally you should be able to open this file always even if SQL Server Agent is started. if you have not rebooted it...

[font="Times New Roman"]Hi Win.

Did you check the entries in <Installation Dir$>\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.OUT ?? It should contain the related error message.

Hope this helps. 🙂

-Sujeet[/font]

Have you tried using the index hints ? you can provide the index name which you want to be used, in the select query. Try it on your mysterious server...

You should upgrade the active node now to SQL Server 2008 before installing the SP1. Then you should run the SP1 on the active node itself after a reboot. Once...