Duty Free!!

SQL Write-Ahead Overhead…

Renaming a Database? Its easy…

Yes..Its easy in SQL Server to rename a database. Just search in the Books Online for “Rename Database” and you get the procedures.

Here are some precautions after renaming a Database : 

1) Check for any Maintenance Plans or Jobs using/optimizing this Database. Those jobs need to be corrected.

2) If there are any Logins on the Database with default DB as the old DB that needs to be corrected as well. ¬†This problem arises because master..syslogins stores the DBName as the default DB rather than the dbid. any particular reason why?? Please let me know incase…

Advertisements

March 4, 2009 Posted by | Uncategorized | Leave a comment