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

Before you restore, check to make sure about the location the restore is
looking for exists, or point it to the location you want to put it in.

I have had this happen quite often until I got the hang of it. The restore
file is from a different server with different file paths set up. You need
to check the location the file is trying to restore to, before you start the
hit the restore button.
Hope this helps,
Nancy
"SQL Brad" <SQLBrad@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D7EC96B7-7941-4253-B462-68032DCF571D@xxxxxxxxxxxxxxxx
Ok, I got a little further...here's what I did...
1. I created a db called dbtest
2. changed to single user mode

When I went to click on the device (the directory where the backup file is
located) I selected the file, did a force overright (one of the errors
that I
encountered told me to check the box makred force overwrite)...anyway,
after
all that I get a single error screen, with a bunch of code on it, here's
the
first line...I tried to copy and paste but that didn't work at
all....ughgh...

Microsoft SQL-DMO (ODBC SQLStateL: 420000)

Device Activation Error. The physical file name C:\Program
Files\Microsoft
SQL Server\MSSQL$Courthouse\Data\c10212_db1_data.MDF may be incorrect

there was also some langage about _Use WITH MOVE and also some stuff about
Log.ldf

does that help and more importantly make sense?

"Immy" wrote:

OK - so, you need to create a new database first.
Do you know the name of the original database that your developer had
setup?
If not, you'll need to just create one with a name that reefers to your
business.
Once you've created your database (simply right click on the Database
folder
and select new database and create it!), you can use my original steps
from
my 1st post to restore your database.

It sounds like your in a bit of limbo at the moment!
Also - RE: the name of your database, if the front end has already been
developed and you don't have any access to the code, you'll need to get
the
correct original DB name. However, you can change this at a later date,
so
dont worry too much about it. At least you'll have a database to play
with
once you've followed the steps i've given.

Good luck
Immy

"SQL Brad" <SQLBrad@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29A1D7F4-04EB-40C2-84E4-BBACD518A823@xxxxxxxxxxxxxxxx
I ran the query...the results are:

master
tempdb
model
msdb
pubs
Northwind...

thanks

"Immy" wrote:

Hmm - it sounds to me as yet that you have not created an empty
database
yet?
Run this and post the results!
select name from master..sysdatabases

also - are you sure you have adequate permissions on the server?

I understand your question, and if you have database readily available
to
restore into you should have a problem with the steps i gave you in
the
original email.



"SQL Brad" <SQLBrad@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:634EDFF9-8ADD-4184-9F54-76D37D68E51F@xxxxxxxxxxxxxxxx
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











.