When you restore a SQL Server database on a different server, SQL Login database users cannot access the database until you fix the permissions. The problem is that the user in the database is an “orphan”. This means that there is no login id or password associated with the user. This is true even if [...]
Posts from ‘November, 2008’
Transaction Log Backups – Doublecheck Script
Have you ever wanted a quick way to check that all of your databases that are either in FULL or BULK_LOGGED recovery mode have transaction log backups setup? The script below is a nice safety net to ensure that all of your non-simple recovery mode databases have transaction log backups setup. Bottom line… if you [...]
SQL Server 2005 Service Pack 3 BETA released
SQL Server 2005 Service Pack 3 BETA is now available. THIS IS A BETA so use with caution. I would advise against applying it to any production servers until the official release of Service Pack 3 and you have fully tested it in your DEV and UAT environments. Download SQL 2005 SP3 BETA Release Notes
