Showing posts with label sqlservr. Show all posts
Showing posts with label sqlservr. Show all posts

Monday, March 26, 2012

Error when restoring master database

Dear all,
I'm working on MS SQL 2000.
I stopped the SQL Server and the SQL Agent services.
and from the prompt:
sqlservr.exe -s MyInstanceName -c -m
then from QA, I've entered my MyInstanceName, user: sa and pwd.
and wrote there:
RESTORE DATABASE master FROM DISK = 'c:\master.bak'
I'm getting an error:
RESTORE DATABASE must be used in single user mode when trying to restore the
master database.
what am I missing'
Thanks in advance
joujI've discovered why. :$
I wasn't using the sqlservr.exe from MSSQl$MyInstanceName\Binn.
My problem now is the server version. I think I should install a Service
Pack for that the versions match.
Thanks.
"jouj" wrote:
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore the
> master database.
> what am I missing'
> Thanks in advance
> jouj|||sqlservr.exe -c - m -s {instancename}
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:C13BA8B2-490A-4365-8591-82C84F2BB0FB@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore
> the
> master database.
> what am I missing'
> Thanks in advance
> jouj