Re: SQL 2000 SP4 on 2003 Server - Single User Mode

Thanks for the quick response....I am trying to RESTORE a database that is in
a backup file .bkp I think. Therefore I am not able to click on it and make
it a single usermode. So, perhaps my question should be, how do you restore
a database from a backup on a brand new clean install of SQL Serve? In
other words, if I had a complete disk failure and I am restoring from backup,
how do I do that, because I cannot enter single user mode ON any of the
pre-installed databases that come with sql server 2000. Does that make
sense? thanks for your help.

"Immy" wrote:

Assuming the database is not already in use - do the following to put the
database into single user mode:
(note you put a DB into single user mode, not the server)

Open Ent.Manager
Select the database in question, right click on it and select properties
Select the OPTIONS tab
Tick Restrict access and then highlight single user.

You need to take it out after you have finished your maintenance.

Immy

"SQL Brad" <SQLBrad@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:735167F4-2B64-45F4-93C1-16DA4C7405AD@xxxxxxxxxxxxxxxx
Here's my situation, I am relatively new to SQL Server and new to 2003
Server. Here's my question. We hired a developer to build a web-site
with
SQL server integration behind it, not a problem. Well, we pretty much
closed
up shop, however and our developer took his server with him, however we
still
have the backups, etc. So, I drug an old (not that old) server and put 2
new
36GB SCSI's in it, installed Small Bus Server 2003, and installed SQL
Server
2000 with SP4. I am trying to replicate the environment as closely as
possible. Anyway, I moved the sql server backup file .bkp to the
c:\program
files\sql server\backup directory and im trying to restore the backup
however
it's telling me that I need to be in single user mode. Can you please
tell
me how to log in to sql server enterprise manager's mmc in single user
mode?

thanks
brad



.

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • 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: Adventures in Server restore
    ... SP1 for exchange change the db jet and should fix this problem ... > I thought I'd pass on my experience in bringing back an exchange server ... I'm not sure what happened (but a online backup was going on) ... > persists then please restore the database from a previous backup. ...
    (microsoft.public.exchange.admin)