Friday, May 18, 2007 - Posts
At first I was amused to see the title and there is lot more information which is granular that you need to know. Replication is intended to be a way of distributing data automatically from a source database to one or more recipient databases. As such,
Read More...
Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server
Read More...
You might have come across this instance of error within your environment: Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>' The above error used to drive me nuts when the users complained by specifying
Read More...
One of my Dev. DBA asked me this question about whether we need to use NOINIT or INIT for a differential backup schedule. Think about availability option in this case, you can overwrite the existing differential backup using INIT clause but when it comes
Read More...