Bringing up SQL Server 2000

Hi,
I was trying to test SQL Server 2000 master database restore and to do that
I stopped MSSQLSERVER service and tried to restart with a single user mode.
However, on typing the command "sqlservr.exe -m" in the Command window it
stops at the point where it says "Using 'xplog70.dll' version '2000.80.760'
to execute extended stored procedure 'xp_msver" and it just does not do
anything.
Then I started it with -m -f option and the last line in the command window
is "2007-03-29 14:18:16.24 spid3 Warning: override, autoexec procedures
skipped." and it does not do anything after that.
Am I doing something wrong? Thanks in advance.All is fine. Leave the command prompt as is, connect using OSQL and execute your RESTORE command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:E80139B2-0AC7-4053-AD17-9907AD851B99@.microsoft.com...
> Hi,
> I was trying to test SQL Server 2000 master database restore and to do that
> I stopped MSSQLSERVER service and tried to restart with a single user mode.
> However, on typing the command "sqlservr.exe -m" in the Command window it
> stops at the point where it says "Using 'xplog70.dll' version '2000.80.760'
> to execute extended stored procedure 'xp_msver" and it just does not do
> anything.
> Then I started it with -m -f option and the last line in the command window
> is "2007-03-29 14:18:16.24 spid3 Warning: override, autoexec procedures
> skipped." and it does not do anything after that.
> Am I doing something wrong? Thanks in advance.|||Thanks for the response. Can you please let me know what commands are used to
run Restore through OSQL and do I run them in the Command Prompt window or
Query analyzer?
"Tibor Karaszi" wrote:
> All is fine. Leave the command prompt as is, connect using OSQL and execute your RESTORE command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:E80139B2-0AC7-4053-AD17-9907AD851B99@.microsoft.com...
> > Hi,
> >
> > I was trying to test SQL Server 2000 master database restore and to do that
> > I stopped MSSQLSERVER service and tried to restart with a single user mode.
> > However, on typing the command "sqlservr.exe -m" in the Command window it
> > stops at the point where it says "Using 'xplog70.dll' version '2000.80.760'
> > to execute extended stored procedure 'xp_msver" and it just does not do
> > anything.
> >
> > Then I started it with -m -f option and the last line in the command window
> > is "2007-03-29 14:18:16.24 spid3 Warning: override, autoexec procedures
> > skipped." and it does not do anything after that.
> >
> > Am I doing something wrong? Thanks in advance.
>
>|||You can open another Command Prompt window (not the one you started SQL
Server in, just leave that alone until you're ready to stop the service) to
run osql or open Query Analyzer. The command to restore a database is
RESTORE DATABASE. You should look up the full syntax of the RESTORE DATABASE
command in the Books Online, study it a bit, and then feel free to ask more
questions.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:EE86914A-42FD-4485-8C33-E5C02400B0EC@.microsoft.com...
> Thanks for the response. Can you please let me know what commands are used
> to
> run Restore through OSQL and do I run them in the Command Prompt window or
> Query analyzer?
> "Tibor Karaszi" wrote:
>> All is fine. Leave the command prompt as is, connect using OSQL and
>> execute your RESTORE command.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "sharman" <sharman@.discussions.microsoft.com> wrote in message
>> news:E80139B2-0AC7-4053-AD17-9907AD851B99@.microsoft.com...
>> > Hi,
>> >
>> > I was trying to test SQL Server 2000 master database restore and to do
>> > that
>> > I stopped MSSQLSERVER service and tried to restart with a single user
>> > mode.
>> > However, on typing the command "sqlservr.exe -m" in the Command window
>> > it
>> > stops at the point where it says "Using 'xplog70.dll' version
>> > '2000.80.760'
>> > to execute extended stored procedure 'xp_msver" and it just does not do
>> > anything.
>> >
>> > Then I started it with -m -f option and the last line in the command
>> > window
>> > is "2007-03-29 14:18:16.24 spid3 Warning: override, autoexec
>> > procedures
>> > skipped." and it does not do anything after that.
>> >
>> > Am I doing something wrong? Thanks in advance.
>>