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

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@discussions.microsoft.com> wrote in message
news:735167F4-2B64-45F4-93C1-16DA4C7405AD@microsoft.com...
> 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

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 .

"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@discussions.microsoft.com> wrote in message
> news:735167F4-2B64-45F4-93C1-16DA4C7405AD@microsoft.com...
> > 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
>
>
>

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@discussions.microsoft.com> wrote in message
news:634EDFF9-8ADD-4184-9F54-76D37D68E51F@microsoft.com...
> 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 .
>
> "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@discussions.microsoft.com> wrote in message
>> news:735167F4-2B64-45F4-93C1-16DA4C7405AD@microsoft.com...
>> > 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
>>
>>
>>

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@discussions.microsoft.com> wrote in message
> news:634EDFF9-8ADD-4184-9F54-76D37D68E51F@microsoft.com...
> > 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 .
> >
> > "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@discussions.microsoft.com> wrote in message
> >> news:735167F4-2B64-45F4-93C1-16DA4C7405AD@microsoft.com...
> >> > 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
> >>
> >>
> >>
>
>
>

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@discussions.microsoft.com> wrote in message
news:29A1D7F4-04EB-40C2-84E4-BBACD518A823@microsoft.com...
>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@discussions.microsoft.com> wrote in message
>> news:634EDFF9-8ADD-4184-9F54-76D37D68E51F@microsoft.com...
>> > 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 .
>> >
>> > "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@discussions.microsoft.com> wrote in message
>> >> news:735167F4-2B64-45F4-93C1-16DA4C7405AD@microsoft.com...
>> >> > 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
>> >>
>> >>
>> >>
>>
>>
>>

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 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@discussions.microsoft.com> wrote in message
> news:29A1D7F4-04EB-40C2-84E4-BBACD518A823@microsoft.com...
> >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@discussions.microsoft.com> wrote in message
> >> news:634EDFF9-8ADD-4184-9F54-76D37D68E51F@microsoft.com...
> >> > 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 .
> >> >
> >> > "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@discussions.microsoft.com> wrote in message
> >> >> news:735167F4-2B64-45F4-93C1-16DA4C7405AD@microsoft.com...
> >> >> > 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
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

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 s,
Nancy
"SQL Brad" <SQLBrad@discussions.microsoft.com> wrote in message
news7EC96B7-7941-4253-B462-68032DCF571D@microsoft.com...
> 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 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@discussions.microsoft.com> wrote in message
>> news:29A1D7F4-04EB-40C2-84E4-BBACD518A823@microsoft.com...
>> >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@discussions.microsoft.com> wrote in message
>> >> news:634EDFF9-8ADD-4184-9F54-76D37D68E51F@microsoft.com...
>> >> > 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 .
>> >> >
>> >> > "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@discussions.microsoft.com> wrote in message
>> >> >> news:735167F4-2B64-45F4-93C1-16DA4C7405AD@microsoft.com...
>> >> >> > 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
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

Nancy, thanks for your response, not sure how I would check that. Should I
rename the SQL Server the same as what is listed below Courthouse? I believe
all the original stuff was in a folder called c:\inetpub\

brad

"Nancy Lytle" wrote:

> 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 s,
> Nancy
> "SQL Brad" <SQLBrad@discussions.microsoft.com> wrote in message
> news7EC96B7-7941-4253-B462-68032DCF571D@microsoft.com...
> > 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 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@discussions.microsoft.com> wrote in message
> >> news:29A1D7F4-04EB-40C2-84E4-BBACD518A823@microsoft.com...
> >> >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@discussions.microsoft.com> wrote in message
> >> >> news:634EDFF9-8ADD-4184-9F54-76D37D68E51F@microsoft.com...
> >> >> > 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 .
> >> >> >
> >> >> > "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@discussions.microsoft.com> wrote in message
> >> >> >> news:735167F4-2B64-45F4-93C1-16DA4C7405AD@microsoft.com...
> >> >> >> > 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
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

nancy and immy,

I found the section where you list the filename to restore to. That did not
seem to work, the error message contained the words use WITH MOVE and I did a
search on that term within SQL and did not find anything, I will look on
technet for that command....thanks

"SQL Brad" wrote:

> Nancy, thanks for your response, not sure how I would check that. Should I
> rename the SQL Server the same as what is listed below Courthouse? I believe
> all the original stuff was in a folder called c:\inetpub\
>
> brad
>
> "Nancy Lytle" wrote:
>
> > 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 s,
> > Nancy
> > "SQL Brad" <SQLBrad@discussions.microsoft.com> wrote in message
> > news7EC96B7-7941-4253-B462-68032DCF571D@microsoft.com...
> > > 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 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@discussions.microsoft.com> wrote in message
> > >> news:29A1D7F4-04EB-40C2-84E4-BBACD518A823@microsoft.com...
> > >> >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@discussions.microsoft.com> wrote in message
> > >> >> news:634EDFF9-8ADD-4184-9F54-76D37D68E51F@microsoft.com...
> > >> >> > 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 .
> > >> >> >
> > >> >> > "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@discussions.microsoft.com> wrote in message
> > >> >> >> news:735167F4-2B64-45F4-93C1-16DA4C7405AD@microsoft.com...
> > >> >> >> > 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
> > >> >> >>
> > >> >> >>
> > >> >> >>
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >