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

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: