Exactly...

For the size of the backups in an average system I dont think there is much excuse for not backing up nightly. It doesnt hurt wont take up much...

I was right 🙂

Replication Monitor automatically registers new publishers when you connect through SQL Management Studio. It is completely safe to remove them from the monitor without any effect...

I'm sorry, I dont follow you. Do you mean you want to remove a registered publisher from replication monitor? If so, right click -> remove. If not...

Alvin Ramard (10/12/2010)

---

I've seen one company cycle the logs files on every server everynight at midnight. This made searching the logs much easier that trying to do it with...

Replication has a built in tablediff tool. Its pretty basic but should do a good job.

There are many great 3rd party tools (with fully functional demos) which will do this. I've found the microsoft built in scripter to be a little "clunky".

My personal favourite...

Error logs will continue to grow throughout the uptime of the server instance. Therefore there is no maximum size. You may want to manually cycle them in periods...

Transactional replication will not continue replicating if the event of an error. You will need to fix the error to allow replication to continue.

From recollection, merge places errors into...

I could be wrong, I'm sure I have renamed a named instance before and never had any issues I couldnt overcome.

I used to do this regularly as I build development...

There are many ways of accomplishing this.

I would probably look into either powershell or telnet (or combination) to verify a service is running. You could probably go retro and...

There's no way of doing it through management studio.

I accomplished this by using powershell and combining multiple resultset along with @@SERVERNAME into a $variable and pinging a HTML email report...

Depends on what you want to do with it. You could load it into a parameter and manipulate/return it or just return the identity as a result set.

DECLARE @Ident...

I wouldnt use DB audit if it was just for SQL Server. However, as you are looking at Oracle auditing as well, DB Audit fits the bill nicely as...

Windows 2008 no longer requires a dedicated network for a heartbeat. It still has a heartbeat, but this can be configured to use a single or dedicated network interface.

http://support.microsoft.com/kb/258750

Note...