I can't restore my master DB

I have 2 servers (Prod & Staging)
Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
Staging is running SQL 2k Enterprise SP2
I can't get the versions to match, thus I can't restore any of my backed up databases to the staging server from the production one.
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device g:\DBBACKUP\Master.bak cannot be restored because it was created by a different version of the server (134218407) than this server (134218262).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I would determine what versions you are running on both, and then upgrade
staging to match production. Is this possible?
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"HELP! Can't Restore DB's" <HELP! Can't Restore
DB's@.discussions.microsoft.com> wrote in message
news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> I have 2 servers (Prod & Staging)
> Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> Staging is running SQL 2k Enterprise SP2
> I can't get the versions to match, thus I can't restore any of my backed
up databases to the staging server from the production one.
>
> Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device g:\DBBACKUP\Master.bak cannot
be restored because it was created by a different version of the server
(134218407) than this server (134218262).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
|||I figured out the problem. A network guy implemented a security fix that altered the version on the production box and he didn't implement the same fix on the Staging box.
"Gregory A. Larsen" wrote:

> I would determine what versions you are running on both, and then upgrade
> staging to match production. Is this possible?
>
> --
> ----
> ----
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "HELP! Can't Restore DB's" <HELP! Can't Restore
> DB's@.discussions.microsoft.com> wrote in message
> news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> up databases to the staging server from the production one.
> be restored because it was created by a different version of the server
> (134218407) than this server (134218262).
>
>

I can't restore my master DB

I have 2 servers (Prod & Staging)
Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
Staging is running SQL 2k Enterprise SP2
I can't get the versions to match, thus I can't restore any of my backed up databases to the staging server from the production one.
---
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device g:\DBBACKUP\Master.bak cannot be restored because it was created by a different version of the server (134218407) than this server (134218262).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.I would determine what versions you are running on both, and then upgrade
staging to match production. Is this possible?
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"HELP! Can't Restore DB's" <HELP! Can't Restore
DB's@.discussions.microsoft.com> wrote in message
news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> I have 2 servers (Prod & Staging)
> Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> Staging is running SQL 2k Enterprise SP2
> I can't get the versions to match, thus I can't restore any of my backed
up databases to the staging server from the production one.
> ---
> Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device g:\DBBACKUP\Master.bak cannot
be restored because it was created by a different version of the server
(134218407) than this server (134218262).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>|||I figured out the problem. A network guy implemented a security fix that altered the version on the production box and he didn't implement the same fix on the Staging box.
"Gregory A. Larsen" wrote:
> I would determine what versions you are running on both, and then upgrade
> staging to match production. Is this possible?
>
> --
> ----
> ----
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "HELP! Can't Restore DB's" <HELP! Can't Restore
> DB's@.discussions.microsoft.com> wrote in message
> news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> > I have 2 servers (Prod & Staging)
> >
> > Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> > Staging is running SQL 2k Enterprise SP2
> >
> > I can't get the versions to match, thus I can't restore any of my backed
> up databases to the staging server from the production one.
> >
> > ---
> >
> > Server: Msg 3168, Level 16, State 1, Line 1
> > The backup of the system database on device g:\DBBACKUP\Master.bak cannot
> be restored because it was created by a different version of the server
> (134218407) than this server (134218262).
> > Server: Msg 3013, Level 16, State 1, Line 1
> > RESTORE DATABASE is terminating abnormally.
> >
>
>

I can't restore my master DB

I have 2 servers (Prod & Staging)
Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
Staging is running SQL 2k Enterprise SP2
I can't get the versions to match, thus I can't restore any of my backed up
databases to the staging server from the production one.
---
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device g:\DBBACKUP\Master.bak cannot be
restored because it was created by a different version of the server (13421
8407) than this server (134218262).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.I would determine what versions you are running on both, and then upgrade
staging to match production. Is this possible?
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"HELP! Can't Restore DB's" <HELP! Can't Restore
DB's@.discussions.microsoft.com> wrote in message
news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> I have 2 servers (Prod & Staging)
> Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> Staging is running SQL 2k Enterprise SP2
> I can't get the versions to match, thus I can't restore any of my backed
up databases to the staging server from the production one.
> ---
> Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device g:\DBBACKUP\Master.bak cannot
be restored because it was created by a different version of the server
(134218407) than this server (134218262).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>|||I figured out the problem. A network guy implemented a security fix that alt
ered the version on the production box and he didn't implement the same fix
on the Staging box.
"Gregory A. Larsen" wrote:

> I would determine what versions you are running on both, and then upgrade
> staging to match production. Is this possible?
>
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "HELP! Can't Restore DB's" <HELP! Can't Restore
> DB's@.discussions.microsoft.com> wrote in message
> news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> up databases to the staging server from the production one.
> be restored because it was created by a different version of the server
> (134218407) than this server (134218262).
>
>

I am getting error Subreport could not be shown

I am trying to call a subreport in master report, if i try to run the sub report individually by passing hardcoded nonqueried values in the parameters it runs fine, but when i use it as subreport in a master report, it shows the error: subreport could not be shown,

In my subreport i am using the table control to populate all fields is there something to do with table control or i am calling the subreport control in the detail pane of main report, and all main reports fields are in the group header.

Please help.

error info: from error list:

Warning 1 [rsErrorExecutingSubreport] An error occurred while executing the subreport ‘subreport1’: One or more parameters required to run the report have not been specified. c:\aspnet\ccsreports2005\ccsreports2005\rptNewIssueHRT.rdl 0 0

Thank you all very much for the info.

Have you mapped the parameters in the master report to the parameters in the subreport? You do that through the properties screen of the subreport object.|||

Hi Adam,

I did mapped the parameters via parameter tab from subreport control.

My subreport is using a table control to populate all columns and there result.

If i run the sub report by itself individually, it runs fine with hardcoded values in it, but when i reference the same thru a subreport control via master report i am getting the error subreport could not be shown.

Please help is there something i am doing a mistake. and also do i need to have the subreports parameters also in master report.

Since under my master report i only have 1 parameter, thats all defined to pull it data, once that data gets in want to use those master datas value to pull the subreports data.

Master report uses stored proc which expects only one parameter, that is what i defined under parameter collection on layout of report.

Thank you very much.

|||So if your master report only has 1 parameter than how did you perform the mapping from the master report to the subreport parameters?|||

I got that error when the subreport was bigger than the textbox in which I placed it. I've also gotten the error when the datasource wasn't quite right, but it looks like you've covered that.

Hope this helps,

Don

|||

Yes, i found the problem yesterday. i am getting the parameter related columns in the dataset but did'nt place it on the report as a column since it is holding ID's in it.

after placing teh column and made it hidden true, then it is able to pull the data on subreport.

Thank you.