Monthly Archives: April 2013

Error: SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name

Often in new environments DBA’s come up with setting up replication. If the server on which the replication is being set up had a different name earlier that the new DBA is not aware of then at the time of … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , , , , , , , | Leave a comment

script to identify list of databases and their recovery model

In this post the focus is on listing all the databases and their recovery models in a sql server instance. This script is used for documenting a list of databases in a SQLServer instance. Below is the script: Hope this … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , , , | Leave a comment

SQL Server Script to list all SQL Server agent jobs

In this post the focus is on identifying the list of sql server agent jobs in an instance. The purpose of listing out all the existing jobs is for documentation just to make sure that the jobs in the list … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , , , , | Leave a comment