Re: msdb renamed to msbd

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 07:58:45 -0600

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

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)