error when trying to restore a sql7 master database

I'm trying to restore a sql7 database on a NT4 Entreprise
SQL server.
I rebuild the master database with Rebuildm.exe and I
start the single user mode with d:\mssql7
\binn\sqlservr.exe -m
When I start the restore with Brighstore ArcServe, I have
this error:
Error: 605. Severity: 21, State: 1.
Error: 63151. Severity: 21, State: 0.
The master database falied to restore. Use the
rebuildm.exe utility to rebuild the master database.
Shutting down SQL Server.
Anyone can help me ?Sorry, you have the wrong usergroup.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Francosi Thibault" <anonymous@.discussions.microsoft.com> wrote in message
news:23a7601c45eac$24a9a520$a401280a@.phx.gbl...
> I'm trying to restore a sql7 database on a NT4 Entreprise
> SQL server.
> I rebuild the master database with Rebuildm.exe and I
> start the single user mode with d:\mssql7
> \binn\sqlservr.exe -m
> When I start the restore with Brighstore ArcServe, I have
> this error:
> Error: 605. Severity: 21, State: 1.
> Error: 63151. Severity: 21, State: 0.
> The master database falied to restore. Use the
> rebuildm.exe utility to rebuild the master database.
> Shutting down SQL Server.
> Anyone can help me ?

Error when running Snapshot Agent

David,
can you have a look at the list of processes and see if
the snapshot.exe is listed, then kill it if it is.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
No - definitely no snapshot.exe.
"Paul Ibison" wrote:

> David,
> can you have a look at the list of processes and see if
> the snapshot.exe is listed, then kill it if it is.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||David,
have a look at sp_removedbreplication, which should
remove any lingering system table traces. Have a look for
any orphaned jobs which are running the snapshot agent.
Also, consider restarting the sql server service.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||An update on this issue:
I disabled replication and distribution on the publisher and distributor
(respectivley) started again.
I was able to start the snapshot agent.
I then received a different error from the snapshot agent:
Invalid object name: syspublications.
Still stuck on this error though.
"Paul Ibison" wrote:

> David,
> have a look at sp_removedbreplication, which should
> remove any lingering system table traces. Have a look for
> any orphaned jobs which are running the snapshot agent.
> Also, consider restarting the sql server service.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>

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

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
jouj
I'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
sql

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 t
he
> 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

Error running SQL 2005 Best Practices Analyzer from command line - Object reference not set to a

I'm getting an error trying to run SQL 2005 Best Practices Analyzer from command line. Here's a sample of the command I run...

SqlBPACmd2005.EXE -u WINLOGON mydomain\\administrator P@.ssw0rd -r Limited -c -a

And here's the error I get...

Object reference not set to an instance of an object

I suspect this partially due to the fact that I left off the -sci option, and this appears to be a required parameter; however, I do not know XML and have not been able to find an example of this file anywhere. Could someone give me an example of an XML file formatted for scanning several 2005 instances?

Does my command have other problems?

Thanks!

Yes, you need to use the -sci options. The XML file can be created through the GUI. Run the GUI, choose the items you wish to scan, then choose, "Export to file". Pass this .xml filename in as the parameter to the -sci command line option.

Does this solve your problem?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server
http://blogs.msdn.com/sqlrem/

Error running rs utility

Hi
Trying to render a report using rs utlitlity however I'm getting the
following problem
The command i issue in the command prompt is:
rs.exe -i RenderReport-SalesOrderMarkup.rss -s
http://server.com/ReportServer -u Domain\
george -p thepassword -v salesid="SO000644" -t
The result;
System.Exception: Could not connect to server:
http://server.com/ReportServer/ReportService.asmx
at
Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
ty()
at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
Any ideas why I'm getting this error?
Thanks
GeorgeJust guessing:
1. Can you go to IE and paste: http://server.com/ReportServer and it comes
back?
2. Can you rename: RenderReport-SalesOrderMarkup.rss, to something without
the "-"
Reeves
"_george" wrote:
> Hi
> Trying to render a report using rs utlitlity however I'm getting the
> following problem
> The command i issue in the command prompt is:
> rs.exe -i RenderReport-SalesOrderMarkup.rss -s
> http://server.com/ReportServer -u Domain\
> george -p thepassword -v salesid="SO000644" -t
> The result;
> System.Exception: Could not connect to server:
> http://server.com/ReportServer/ReportService.asmx
> at
> Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
> ty()
> at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> Bas
> eCmdLine instance)
>
> Any ideas why I'm getting this error?
> Thanks
> George
>
>