msdb renamed to msbd

Hello,
Yesterday i was trying to install a backup client for sql on our sql server,
it kept on failing so i contacted the software vendor to see if there was a
problem with the client. after they poked around on our sql server they rea
lized that one of the datab
ases had been renamed, for what reason i dont know. The msdb database was re
named to msbd. This is the reason that we can not install the backup agent s
oftware. Does anyone out there know how to rename the database, the physical
name of the database file
is fine its the display name inside of Enterprise manager.
ThanksHi,
Refer sp_renamedb in books online
sp_renamedb [ @.dbname = ] 'old_name' ,
[ @.newname = ] 'new_name'
Thanks
Hari
MCDBA
"Brian Butler" <anonymous@.discussions.microsoft.com> wrote in message
news:564BE6BC-5201-4828-A0B3-9E1450653B3A@.microsoft.com...
> Hello,
> Yesterday i was trying to install a backup client for sql on our sql
server, it kept on failing so i contacted the software vendor to see if
there was a problem with the client. after they poked around on our sql
server they realized that one of the databases had been renamed, for what
reason i dont know. The msdb database was renamed to msbd. This is the
reason that we can not install the backup agent software. Does anyone out
there know how to rename the database, the physical name of the database
file is fine its the display name inside of Enterprise manager.
> Thanks|||In SQL 2000, an alternative to sp_renamedb is ALTER DATABASE:
ALTER DATABASE msbd
MODIFY NAME = msdb
Hope this helps.
Dan Guzman
SQL Server MVP
"Brian Butler" <anonymous@.discussions.microsoft.com> wrote in message
news:564BE6BC-5201-4828-A0B3-9E1450653B3A@.microsoft.com...
> Hello,
> Yesterday i was trying to install a backup client for sql on our sql
server, it kept on failing so i contacted the software vendor to see if
there was a problem with the client. after they poked around on our sql
server they realized that one of the databases had been renamed, for what
reason i dont know. The msdb database was renamed to msbd. This is the
reason that we can not install the backup agent software. Does anyone out
there know how to rename the database, the physical name of the database
file is fine its the display name inside of Enterprise manager.
> Thanks