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 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 when importing data from Excel File

Hi!

This is what i'm doing:

IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid !=

0 AND srv.srvname = N'ExcelSource')

EXEC master.dbo.sp_dropserver @.server=N'ExcelSource', @.droplogins='droplogins';
-
EXEC master.dbo.sp_addlinkedserver
@.server = 'ExcelSource',
@.srvproduct = 'Excel',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.datasrc = @.Chemin,
@.provstr = 'Excel 8.0';

EXEC master.dbo.sp_addlinkedsrvlogin
@.rmtsrvname = 'ExcelSource',
@.useself = false,
@.locallogin = NULL,
@.rmtuser ='ADMIN',
@.rmtpassword = NULL;

set @.NomServ = 'ExcelSource';

This create a linkedServer to read my ExcelFile.

Then i'm doing this:

EXEC ('Insert into Elements (No_element, Nom_elem, Desc_elem, Code_grpe_classe, Tps_elem, Code_sgrpe, Code_produit)
Select No_element, Nom_elem, Desc_elem, Code_grpe_classe, Tps_elem, Code_sgrpe, Code_produit
from ' + @.NomServ + '...[Elements$];')

This is where i got an error. The error is:
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ExcelSource" does not contain the table "Elements$". The table either does not exist or the current user does not have permissions on that table.

I can't figure out what i'm missing. I've add permissions for EVERYONE on the file and on the folder just to be sure and i still have the same error. How can i check if the table [Elements$] exist ?
I've forgot to mention that my excel spreadsheet name is Elements.|||I finally found what the problem was. One of my column name had the wrong Column name. Now it's working fine !

Error when calling a Sub report (Jump to report)

I have created a two reports with a parameterized query - one master and one sub report.
When I want to call the sub report from the master report I would like to be able to pass the values for the parameters in to the sub report.

And I also don′t want the passed parameters to be prompted in the sub report (so I blanked out the 'Prompt:' field).

But I got following error:
The report parameter 'parameter name' is read-only and cannot be modified.

What to do?

Running Report Server: 8.00.743.00

/Christofer

Instead of blanking the Prompt field, check the 'Hidden' checkbox.|||

Well...
Should it be in the Report Parameters dialog box where I define parameters?
If so, I can′t find this checkbox "Hidden" in my version, or where should I find it?

Regards,
Christofer

Error traping in DTS

I am using a DTS for my purpose and I am calling that DTS execution in a stored procedure(using master..xp_cmdshell dtsrun/F).I like to store the error meassage or error description in the Stored Procedure if it fails due to any reason.How can I do that?call the dtsrun also with /L<log file path >|||Will you kindly give me a brief of that please?|||dtsrun gets some arguments the /L <file path > switch "tells" dtsrun where to log it executed steps results
for more info search books online for "dtsrun Utility" there you can find all info about dtsrun.

Error running sp_helpdb

When I run sp_helpdb against the master (or any other DB for that matter) I get the following error:

Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53
Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc_ 0010001A6EF'; column does not allow nulls. INSERT fails. The statement has been terminated.

I have about 20 DBs on a SQL Server 2000 Standard Edition Instance with sp3a .

There have been no changes made to the Server or the SQL Server Instance in quite some time. Can anyone tell me how I should proceed??I think spid is null in master.dbo.sysdatabases,
check that first.

select spid from master.dbo.sysdatabases
u can use sp, sp_changedbowner 'ownername' if it is null .

And check that link,it may help u.
http://dbforums.com/t554105.html|||I did check select * from master.dbo.sysdatabases and I don't see anything unusual. and thanks.. but that other post wasn't very helpful... : (

I did some poking around and noticed that when I look at the properties of my Model and msdb databases in Enterprise Manager, they BOTH have {unknown} for Owner !!?? that CAN'T be a good thing !!
I checked BOL for sp_changedbowner and it says that you can't change the owner on master, msdb and ,model - so I'm a little leary to try it... Anyone have an suggestions? ... please..

Can I use sp_changdbowner on model and msdb if they are already Null or as Enterprise Manager puts it... UNKNOWN ? ?|||Yes u cannot chage owner of master,msdb and model db,Onlyway is,


eg:this will will change model db owner to 'sa'
exec sp_configure 'allow updates', 1
RECONFIGURE WITH OVERRIDE
go
update sysdatabases
set sid = 0x01
where name = 'model'
go
sp_configure 'allow updates', 0
RECONFIGURE WITH OVERRIDE|||Can I ask a dumb question??

How does that code change the owner? I see where it sets the SID. and, should the SID be set the same for model and msdb?|||0x01 is the sid of sa user,msdb,model db's owner should be under sa.

u can see that in,

select name, suser_sname(sid),sid
from master.dbo.sysdatabases|||Told you it was a dumb question. Thanks much!