HELP! Restore SQL7 database to SQL2000 SP3a problem

I have a small database that urgently needs restoring under SQL 2000.
SP3a is installed.
Is there a procedure?
Yes.
First obtain three chickens and a mule...
Seriously, a SQL 7.0 database can be restored (or attached after detach) to
a SQL 2000 instance using the normal restore database commands or Enterprise
Manager. There is no difference in restoring a 7.0 backup to a SQL 2000
server than in restoring a SQL 2000 backup to a SQL 2000 server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132770162.841008.102880@.o13g2000cwo.googlegr oups.com...
>I have a small database that urgently needs restoring under SQL 2000.
> SP3a is installed.
> Is there a procedure?
>
|||You can use a RESTORE DATABASE command. For example:
RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatabase.bak'
WITH REPLACE
See the Books Online for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132770162.841008.102880@.o13g2000cwo.googlegr oups.com...
>I have a small database that urgently needs restoring under SQL 2000.
> SP3a is installed.
> Is there a procedure?
>
|||Thanks Geoff,
The error I am getting is:
SQL-DMO (ODBC SQLstate: 42000)
The media set for database (name) has 2 family members but only 1 are
provided. All members must be provided. Restore database is
terminating... "
S.
|||Evidently your backup spanned multiple backup sets (files or tapes). You
need to specify all backup sets in a single restore command:
RESTORE DATABASE MySQL7Database
FROM C:\Backups\MySQL7Backup1.bak,C:\Backups\MySQL7Back up2.bak
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132773276.165857.173410@.z14g2000cwz.googlegr oups.com...
> Thanks Geoff,
> The error I am getting is:
> SQL-DMO (ODBC SQLstate: 42000)
> The media set for database (name) has 2 family members but only 1 are
> provided. All members must be provided. Restore database is
> terminating... "
> S.
>
|||Geoff, thanks
No, this was not the case. The database backup file was created in SQL
Server 7 (SP4) and zips to 2MB after backup.
On selection of the database file it's backup set properties can be
seen. I selected to restore All, and there is no existing database over
which it will overwrite. So it is hard to see why it should be asking
for another file.
Are there any other settings that can be changed? I am having a look...
S.
|||Well guys, thanks very much anyway. I have tried using Dan Guzman's
suggestion of running a command script, but still no good - same error
type. I suppose that somehow there must be a corruption, as whenever I
have previously backed up the system it has been plain sailing to get
it back in again. But that was in SQL 7.
I shall get another backup (500 Km away!), unless you can advise more.
|||It might be that the actual backup spans multiple files, even though you
have only one of the members. You can see if this is your situation by
examining FamilyCount of the RESTORE LABELONLY results:
RESTORE LABELONLY
FROM DISK='C:\Backups\MyDatabase.bak'
Hope this helps.
Dan Guzman
SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132774484.545986.59230@.o13g2000cwo.googlegro ups.com...
> Geoff, thanks
> No, this was not the case. The database backup file was created in SQL
> Server 7 (SP4) and zips to 2MB after backup.
> On selection of the database file it's backup set properties can be
> seen. I selected to restore All, and there is no existing database over
> which it will overwrite. So it is hard to see why it should be asking
> for another file.
> Are there any other settings that can be changed? I am having a look...
> S.
>
|||The backup is striped. I never seen a case where SQL Server said it is, but it wasn't. Use RESTORE
LABELONLY as suggested by Dan, and you will see the number of members. I.e., you need to get the
other backup files, or a new non-striped backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132774484.545986.59230@.o13g2000cwo.googlegro ups.com...
> Geoff, thanks
> No, this was not the case. The database backup file was created in SQL
> Server 7 (SP4) and zips to 2MB after backup.
> On selection of the database file it's backup set properties can be
> seen. I selected to restore All, and there is no existing database over
> which it will overwrite. So it is hard to see why it should be asking
> for another file.
> Are there any other settings that can be changed? I am having a look...
> S.
>

HELP! Restore SQL7 database to SQL2000 SP3a problem

I have a small database that urgently needs restoring under SQL 2000.
SP3a is installed.
Is there a procedure?Yes.
First obtain three chickens and a mule...
Seriously, a SQL 7.0 database can be restored (or attached after detach) to
a SQL 2000 instance using the normal restore database commands or Enterprise
Manager. There is no difference in restoring a 7.0 backup to a SQL 2000
server than in restoring a SQL 2000 backup to a SQL 2000 server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132770162.841008.102880@.o13g2000cwo.googlegroups.com...
>I have a small database that urgently needs restoring under SQL 2000.
> SP3a is installed.
> Is there a procedure?
>|||You can use a RESTORE DATABASE command. For example:
RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatabase.bak'
WITH REPLACE
See the Books Online for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132770162.841008.102880@.o13g2000cwo.googlegroups.com...
>I have a small database that urgently needs restoring under SQL 2000.
> SP3a is installed.
> Is there a procedure?
>|||Thanks Geoff,
The error I am getting is:
SQL-DMO (ODBC SQLstate: 42000)
The media set for database (name) has 2 family members but only 1 are
provided. All members must be provided. Restore database is
terminating... "
S.|||Evidently your backup spanned multiple backup sets (files or tapes). You
need to specify all backup sets in a single restore command:
RESTORE DATABASE MySQL7Database
FROM C:\Backups\MySQL7Backup1.bak,C:\Backups\MySQL7Backup2.bak
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132773276.165857.173410@.z14g2000cwz.googlegroups.com...
> Thanks Geoff,
> The error I am getting is:
> SQL-DMO (ODBC SQLstate: 42000)
> The media set for database (name) has 2 family members but only 1 are
> provided. All members must be provided. Restore database is
> terminating... "
> S.
>|||Geoff, thanks
No, this was not the case. The database backup file was created in SQL
Server 7 (SP4) and zips to 2MB after backup.
On selection of the database file it's backup set properties can be
seen. I selected to restore All, and there is no existing database over
which it will overwrite. So it is hard to see why it should be asking
for another file.
Are there any other settings that can be changed? I am having a look...
S.|||Well guys, thanks very much anyway. I have tried using Dan Guzman's
suggestion of running a command script, but still no good - same error
type. I suppose that somehow there must be a corruption, as whenever I
have previously backed up the system it has been plain sailing to get
it back in again. But that was in SQL 7.
I shall get another backup (500 Km away!), unless you can advise more.|||It might be that the actual backup spans multiple files, even though you
have only one of the members. You can see if this is your situation by
examining FamilyCount of the RESTORE LABELONLY results:
RESTORE LABELONLY
FROM DISK='C:\Backups\MyDatabase.bak'
Hope this helps.
Dan Guzman
SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132774484.545986.59230@.o13g2000cwo.googlegroups.com...
> Geoff, thanks
> No, this was not the case. The database backup file was created in SQL
> Server 7 (SP4) and zips to 2MB after backup.
> On selection of the database file it's backup set properties can be
> seen. I selected to restore All, and there is no existing database over
> which it will overwrite. So it is hard to see why it should be asking
> for another file.
> Are there any other settings that can be changed? I am having a look...
> S.
>|||The backup is striped. I never seen a case where SQL Server said it is, but
it wasn't. Use RESTORE
LABELONLY as suggested by Dan, and you will see the number of members. I.e.,
you need to get the
other backup files, or a new non-striped backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132774484.545986.59230@.o13g2000cwo.googlegroups.com...
> Geoff, thanks
> No, this was not the case. The database backup file was created in SQL
> Server 7 (SP4) and zips to 2MB after backup.
> On selection of the database file it's backup set properties can be
> seen. I selected to restore All, and there is no existing database over
> which it will overwrite. So it is hard to see why it should be asking
> for another file.
> Are there any other settings that can be changed? I am having a look...
> S.
>

HELP! Restore SQL7 database to SQL2000 SP3a problem

I have a small database that urgently needs restoring under SQL 2000.
SP3a is installed.
Is there a procedure?Yes.
First obtain three chickens and a mule...
Seriously, a SQL 7.0 database can be restored (or attached after detach) to
a SQL 2000 instance using the normal restore database commands or Enterprise
Manager. There is no difference in restoring a 7.0 backup to a SQL 2000
server than in restoring a SQL 2000 backup to a SQL 2000 server.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132770162.841008.102880@.o13g2000cwo.googlegroups.com...
>I have a small database that urgently needs restoring under SQL 2000.
> SP3a is installed.
> Is there a procedure?
>|||You can use a RESTORE DATABASE command. For example:
RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatabase.bak'
WITH REPLACE
See the Books Online for details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132770162.841008.102880@.o13g2000cwo.googlegroups.com...
>I have a small database that urgently needs restoring under SQL 2000.
> SP3a is installed.
> Is there a procedure?
>|||Thanks Geoff,
The error I am getting is:
SQL-DMO (ODBC SQLstate: 42000)
The media set for database (name) has 2 family members but only 1 are
provided. All members must be provided. Restore database is
terminating... "
S.|||Evidently your backup spanned multiple backup sets (files or tapes). You
need to specify all backup sets in a single restore command:
RESTORE DATABASE MySQL7Database
FROM C:\Backups\MySQL7Backup1.bak,C:\Backups\MySQL7Backup2.bak
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132773276.165857.173410@.z14g2000cwz.googlegroups.com...
> Thanks Geoff,
> The error I am getting is:
> SQL-DMO (ODBC SQLstate: 42000)
> The media set for database (name) has 2 family members but only 1 are
> provided. All members must be provided. Restore database is
> terminating... "
> S.
>|||Geoff, thanks
No, this was not the case. The database backup file was created in SQL
Server 7 (SP4) and zips to 2MB after backup.
On selection of the database file it's backup set properties can be
seen. I selected to restore All, and there is no existing database over
which it will overwrite. So it is hard to see why it should be asking
for another file.
Are there any other settings that can be changed? I am having a look...
S.|||Well guys, thanks very much anyway. I have tried using Dan Guzman's
suggestion of running a command script, but still no good - same error
type. I suppose that somehow there must be a corruption, as whenever I
have previously backed up the system it has been plain sailing to get
it back in again. But that was in SQL 7.
I shall get another backup (500 Km away!), unless you can advise more.|||It might be that the actual backup spans multiple files, even though you
have only one of the members. You can see if this is your situation by
examining FamilyCount of the RESTORE LABELONLY results:
RESTORE LABELONLY
FROM DISK='C:\Backups\MyDatabase.bak'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132774484.545986.59230@.o13g2000cwo.googlegroups.com...
> Geoff, thanks
> No, this was not the case. The database backup file was created in SQL
> Server 7 (SP4) and zips to 2MB after backup.
> On selection of the database file it's backup set properties can be
> seen. I selected to restore All, and there is no existing database over
> which it will overwrite. So it is hard to see why it should be asking
> for another file.
> Are there any other settings that can be changed? I am having a look...
> S.
>|||The backup is striped. I never seen a case where SQL Server said it is, but it wasn't. Use RESTORE
LABELONLY as suggested by Dan, and you will see the number of members. I.e., you need to get the
other backup files, or a new non-striped backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"proverbs3" <seumas.maclaren@.atkinsglobal.com> wrote in message
news:1132774484.545986.59230@.o13g2000cwo.googlegroups.com...
> Geoff, thanks
> No, this was not the case. The database backup file was created in SQL
> Server 7 (SP4) and zips to 2MB after backup.
> On selection of the database file it's backup set properties can be
> seen. I selected to restore All, and there is no existing database over
> which it will overwrite. So it is hard to see why it should be asking
> for another file.
> Are there any other settings that can be changed? I am having a look...
> S.
>sql

Help! Printing Error from client (browser)

We have 2 servers with RS:

1.SQL RS 2000 SP3a

2.SQL RS 2005 SP1

When we try to use client side printing in SQL 2000 RS we getting error "An error occured during printing '0x8007F304' ".

When we try to use client side printing (from the same client PC) in SQL 2005 RS, it print fine without any problem

Thank you,

Lenn

Please check this posts

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=247869&SiteID=1

|||

That post refering to installing SQL2005 SP1 to fix printing problem. We have SQL2005 SP1 installed on 2005 server, but reports are not prints when RS running to SQL 2000 server!!

Thanks,

Lenn

HELP! EM wont connect after apply sp3a,reporting services and VS.net 2003

Install SQL 2000 on a completelyu up to date windows 2003 advanced server,
then applied sp3a, then a installed reporting service developer addition,
then installed VS .net 2003 the reinstalled reporting services to get the
Report Developer.
Now I can't connect to the Server using EM.
Get SQL_alloc_handle on SQL_handle_env failed.
Tried all types of registrations.
Any suggestions short of starting from scratch?Make an ODBC trace of the connection attempt & open a case with the Webdata
team. They handle the MDAC problems with SQL.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Will do that if re-install of tools SQL fails. How do I open a case with the
WEBdata Team.
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:XWmAGmZ9DHA.704@.cpmsftngxa07.phx.gbl...
> Make an ODBC trace of the connection attempt & open a case with the
Webdata
> team. They handle the MDAC problems with SQL.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

HELP! Can't connect to MSDE using Enterprise manger

I installed an instance (only one) of MSDE200 sp3a on one of the desktop machine (XP pro sp1), I would like to manage it by using the enterprise manager installed on another machine on the same network. I was getting the "SQL server does not exist or acce
ss denied" error. I am sure I have enter the proper login info and the MSDE is running.
Is there any configuration need to be done on the MSDE? any expert here can help me on this?
Thanks
Henry
hi Henry,
"Henry" <henryli1222@.msn.com> ha scritto nel messaggio
news:6AB45DD1-DA80-440E-B338-EA8F5467358F@.microsoft.com...
> I installed an instance (only one) of MSDE200 sp3a on one of the desktop
machine (XP pro sp1), I would like to manage it by using the enterprise
manager installed on another machine on the same network. I was getting the
"SQL server does not exist or access denied" error. I am sure I have enter
the proper login info and the MSDE is running.
> Is there any configuration need to be done on the MSDE? any expert here
can help me on this?
>
probably you installed the remote MSDE instance with the default parameter
which disable network protocols for it, not allowing remote connections to
that server...
please run svrnetcn.exe (Server Net Utility) on that server to verify the
desired network protocols are enabled...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, it works. It's possible to enable the network protocals for the MSDE 2000 installation?
|||Hi Henry,
You can do this by executing svrnetcn.exe.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:773EC08B-D846-4AB5-AA82-35034BD9375F@.microsoft.com...
> Thanks, it works. It's possible to enable the network protocals for the
MSDE 2000 installation?