Restore DB to new Database Name Cannot see new Database SQL2000

Hi
I wanted to create a test database based on formally live data in SQL2000.
I created the new Database and then forced a restore from a backup.
Unfortunately the client workstations cannot see the new database.
Any ideas?
Many thanks
Mike
When you say client workstations... do mean via the QUery Analyzer?
Perhaps the user information is messed up in the restored database and
the users/roles need to be dropped and re-added? I'm guessing you
restored via EM.
"Mike" <mikevl@.paradise.net.nz> wrote in message
news:uXNxm2bzEHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi
> I wanted to create a test database based on formally live data in SQL2000.
> I created the new Database and then forced a restore from a backup.
> Unfortunately the client workstations cannot see the new database.
> Any ideas?
> Many thanks
> Mike
>
|||Thanks for your help
It appears that the financial application based on SQL would only find
databases with a certain prefix name. Real cleaver. Took a while to find.
Many thanks
Mike
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message
news:OhWVVsdzEHA.1404@.TK2MSFTNGP11.phx.gbl...
> When you say client workstations... do mean via the QUery Analyzer?
> Perhaps the user information is messed up in the restored database and
> the users/roles need to be dropped and re-added? I'm guessing you
> restored via EM.
> "Mike" <mikevl@.paradise.net.nz> wrote in message
> news:uXNxm2bzEHA.2624@.TK2MSFTNGP11.phx.gbl...
>

Restore DB to new Database Name Cannot see new Database SQL2000

Hi
I wanted to create a test database based on formally live data in SQL2000.
I created the new Database and then forced a restore from a backup.
Unfortunately the client workstations cannot see the new database.
Any ideas?
Many thanks
MikeWhen you say client workstations... do mean via the QUery Analyzer?
Perhaps the user information is messed up in the restored database and
the users/roles need to be dropped and re-added? I'm guessing you
restored via EM.
"Mike" <mikevl@.paradise.net.nz> wrote in message
news:uXNxm2bzEHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi
> I wanted to create a test database based on formally live data in SQL2000.
> I created the new Database and then forced a restore from a backup.
> Unfortunately the client workstations cannot see the new database.
> Any ideas?
> Many thanks
> Mike
>|||Thanks for your help
It appears that the financial application based on SQL would only find
databases with a certain prefix name. Real cleaver. Took a while to find.
Many thanks
Mike
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message
news:OhWVVsdzEHA.1404@.TK2MSFTNGP11.phx.gbl...
> When you say client workstations... do mean via the QUery Analyzer?
> Perhaps the user information is messed up in the restored database and
> the users/roles need to be dropped and re-added? I'm guessing you
> restored via EM.
> "Mike" <mikevl@.paradise.net.nz> wrote in message
> news:uXNxm2bzEHA.2624@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> I wanted to create a test database based on formally live data in
>> SQL2000.
>> I created the new Database and then forced a restore from a backup.
>> Unfortunately the client workstations cannot see the new database.
>> Any ideas?
>> Many thanks
>> Mike
>>
>

Restore DB to new Database Name Cannot see new Database SQL2000

Hi
I wanted to create a test database based on formally live data in SQL2000.
I created the new Database and then forced a restore from a backup.
Unfortunately the client workstations cannot see the new database.
Any ideas?
Many thanks
MikeWhen you say client workstations... do mean via the QUery Analyzer?
Perhaps the user information is messed up in the restored database and
the users/roles need to be dropped and re-added? I'm guessing you
restored via EM.
"Mike" <mikevl@.paradise.net.nz> wrote in message
news:uXNxm2bzEHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi
> I wanted to create a test database based on formally live data in SQL2000.
> I created the new Database and then forced a restore from a backup.
> Unfortunately the client workstations cannot see the new database.
> Any ideas?
> Many thanks
> Mike
>|||Thanks for your help
It appears that the financial application based on SQL would only find
databases with a certain prefix name. Real cleaver. Took a while to find.
Many thanks
Mike
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message
news:OhWVVsdzEHA.1404@.TK2MSFTNGP11.phx.gbl...
> When you say client workstations... do mean via the QUery Analyzer?
> Perhaps the user information is messed up in the restored database and
> the users/roles need to be dropped and re-added? I'm guessing you
> restored via EM.
> "Mike" <mikevl@.paradise.net.nz> wrote in message
> news:uXNxm2bzEHA.2624@.TK2MSFTNGP11.phx.gbl...
>

restore db

How do you restore the backup of a SQL2000 DB to SQL2005 DB? Thanks.Sorry Folks, I got it now. Is the restoration 100% compactible to SQL 2005?
"00KobeBrian" <a@.b.com> wrote in message
news:%23WUHmKR6GHA.3508@.TK2MSFTNGP06.phx.gbl...
> How do you restore the backup of a SQL2000 DB to SQL2005 DB? Thanks.
>|||Yes, you can restore a SQL Server 2000 backup to SQL Server 2005.
You cannot go the other way, however.
--
Keith Kratochvil
"00KobeBrian" <a@.b.com> wrote in message
news:%23zgikYR6GHA.4996@.TK2MSFTNGP04.phx.gbl...
> Sorry Folks, I got it now. Is the restoration 100% compactible to SQL
> 2005?
>
> "00KobeBrian" <a@.b.com> wrote in message
> news:%23WUHmKR6GHA.3508@.TK2MSFTNGP06.phx.gbl...
>> How do you restore the backup of a SQL2000 DB to SQL2005 DB? Thanks.
>

restore db

How do you restore the backup of a SQL2000 DB to SQL2005 DB? Thanks.
Sorry Folks, I got it now. Is the restoration 100% compactible to SQL 2005?
"00KobeBrian" <a@.b.com> wrote in message
news:%23WUHmKR6GHA.3508@.TK2MSFTNGP06.phx.gbl...
> How do you restore the backup of a SQL2000 DB to SQL2005 DB? Thanks.
>
|||Yes, you can restore a SQL Server 2000 backup to SQL Server 2005.
You cannot go the other way, however.
Keith Kratochvil
"00KobeBrian" <a@.b.com> wrote in message
news:%23zgikYR6GHA.4996@.TK2MSFTNGP04.phx.gbl...
> Sorry Folks, I got it now. Is the restoration 100% compactible to SQL
> 2005?
>
> "00KobeBrian" <a@.b.com> wrote in message
> news:%23WUHmKR6GHA.3508@.TK2MSFTNGP06.phx.gbl...
>

restore db

How do you restore the backup of a SQL2000 DB to SQL2005 DB? Thanks.Sorry Folks, I got it now. Is the restoration 100% compactible to SQL 2005?
"00KobeBrian" <a@.b.com> wrote in message
news:%23WUHmKR6GHA.3508@.TK2MSFTNGP06.phx.gbl...
> How do you restore the backup of a SQL2000 DB to SQL2005 DB? Thanks.
>|||Yes, you can restore a SQL Server 2000 backup to SQL Server 2005.
You cannot go the other way, however.
Keith Kratochvil
"00KobeBrian" <a@.b.com> wrote in message
news:%23zgikYR6GHA.4996@.TK2MSFTNGP04.phx.gbl...
> Sorry Folks, I got it now. Is the restoration 100% compactible to SQL
> 2005?
>
> "00KobeBrian" <a@.b.com> wrote in message
> news:%23WUHmKR6GHA.3508@.TK2MSFTNGP06.phx.gbl...
>

Restore databse SQL7 to SQL2000

Hi
I am trying to restore a SQL7 database to an SQL2000 server. The
restore only manages to restore the tables. It does not restore the
data. What am I doing wong ? Any help will be appreciated.RESTORE does give you an image of the database. Perhaps you by mistake restored the wrong backup?
Can you do SELECT COUNT(*) FROM tblname on some of the table to determine the number of rows in
them?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Arian" <arian@.rocketmail.com> wrote in message
news:1108737187.461333.17340@.l41g2000cwc.googlegroups.com...
> Hi
> I am trying to restore a SQL7 database to an SQL2000 server. The
> restore only manages to restore the tables. It does not restore the
> data. What am I doing wong ? Any help will be appreciated.
>|||I got the backup from a client. Since I only have one backup that
could'nt be the problem.
On count I get 0 on most of the tables.
The database size was 798mb on the sql 7 server and the backup is 109
mb and the restored db is 798. So the size of the db matches.|||Hi Tibor
Managed to sort it. I did the restore thru query analyzer with the
following syntax and it worked fine.
RESTORE DATABASE mydb FROM disk='d:\mssql7\backup\mydb_db.bak'
WITH MOVE 'mydbdata' TO 'd:\mssql7\data\mydbdata.mdf',
MOVE 'mydblog' TO 'd:\mssql7\data\mydblog.ldf',
REPLACE
go

Restore databse SQL7 to SQL2000

Hi
I am trying to restore a SQL7 database to an SQL2000 server. The
restore only manages to restore the tables. It does not restore the
data. What am I doing wong ? Any help will be appreciated.
RESTORE does give you an image of the database. Perhaps you by mistake restored the wrong backup?
Can you do SELECT COUNT(*) FROM tblname on some of the table to determine the number of rows in
them?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Arian" <arian@.rocketmail.com> wrote in message
news:1108737187.461333.17340@.l41g2000cwc.googlegro ups.com...
> Hi
> I am trying to restore a SQL7 database to an SQL2000 server. The
> restore only manages to restore the tables. It does not restore the
> data. What am I doing wong ? Any help will be appreciated.
>
|||I got the backup from a client. Since I only have one backup that
could'nt be the problem.
On count I get 0 on most of the tables.
The database size was 798mb on the sql 7 server and the backup is 109
mb and the restored db is 798. So the size of the db matches.
|||Hi Tibor
Managed to sort it. I did the restore thru query analyzer with the
following syntax and it worked fine.
RESTORE DATABASE mydb FROM disk='d:\mssql7\backup\mydb_db.bak'
WITH MOVE 'mydbdata' TO 'd:\mssql7\data\mydbdata.mdf',
MOVE 'mydblog' TO 'd:\mssql7\data\mydblog.ldf',
REPLACE
go

Restore databse SQL7 to SQL2000

Hi
I am trying to restore a SQL7 database to an SQL2000 server. The
restore only manages to restore the tables. It does not restore the
data. What am I doing wong ? Any help will be appreciated.RESTORE does give you an image of the database. Perhaps you by mistake resto
red the wrong backup?
Can you do SELECT COUNT(*) FROM tblname on some of the table to determine th
e number of rows in
them?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Arian" <arian@.rocketmail.com> wrote in message
news:1108737187.461333.17340@.l41g2000cwc.googlegroups.com...
> Hi
> I am trying to restore a SQL7 database to an SQL2000 server. The
> restore only manages to restore the tables. It does not restore the
> data. What am I doing wong ? Any help will be appreciated.
>|||I got the backup from a client. Since I only have one backup that
could'nt be the problem.
On count I get 0 on most of the tables.
The database size was 798mb on the sql 7 server and the backup is 109
mb and the restored db is 798. So the size of the db matches.|||Hi Tibor
Managed to sort it. I did the restore thru query analyzer with the
following syntax and it worked fine.
RESTORE DATABASE mydb FROM disk='d:\mssql7\backup\mydb_db.bak'
WITH MOVE 'mydbdata' TO 'd:\mssql7\data\mydbdata.mdf',
MOVE 'mydblog' TO 'd:\mssql7\data\mydblog.ldf',
REPLACE
go

restore a SQL2000 db to a SQL7.0 server

How to restore a database dump file (.BAK) that backed up from SQL
2000 server to a SQL 7.0 server?
Please help.
SaiyouAs far as I know you cannot do this, you can only do it the other way
around.
Obviously, you could connect the dbs and transfer objects

JV
__________________________________________________ ________________
Remotely manage MS SQL db with SQLdirector -
www.ciquery.com/tools/sqldirector/

"Saiyou Anh" <wangc@.alexian.net> wrote in message
news:a51d3ca7.0309091153.7b581396@.posting.google.c om...
> How to restore a database dump file (.BAK) that backed up from SQL
> 2000 server to a SQL 7.0 server?
> Please help.
> Saiyou

Restore a single file from the database

Hello,
We have running sql2000 and we want to use a database where users can store
files in it. My question is: is it possible to restore a single file from
that database?
Thanx in advance
Marco Gorissen
marco.gorissen@.icts.unimaas.nlHi,
You can use text data type with file name as a different column. Using this
you can retive a single file from the SQL table.
select textcolumn from table where filename='filename.txt'
Did I answer your question correctly ?
Thanks
Hari
MCDBA
"Marco Gorissen" <marco.gorissen@.icts.unimaas.nl> wrote in message
news:e0R3b2c1DHA.3216@.TK2MSFTNGP11.phx.gbl...
> Hello,
> We have running sql2000 and we want to use a database where users can
store
> files in it. My question is: is it possible to restore a single file from
> that database?
> Thanx in advance
> Marco Gorissen
> marco.gorissen@.icts.unimaas.nl
>

Restore a set of databases from a SQL2000 server to a SQL2005 server

I can restore databases one by one, setting .mdf and .ldf destination paths.

How can I restore all my Databases at the same time?

Thanks

G. Zanghi

You will either have restore or attach them one by one.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

In SQL2000 i have a script that permits me to restore, at the same time, a group of databases backed up with a maintenance plan.

In SQL2005 this script doesn't run. Do you know a similar one?

Restoring one by one it's an hard work....

|||COuld you send me over the script, perhaps I can try a transistion. My EMail is accessible through my profile.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Your Email doesn't run!

check this link: fengyu.china.com/source/sp_CSS_RestoreDir.sql

It's very similar to mine.

|||My Email works, you actually will have to remove the SPAMfuscator to make it work. Which error do you get ? If you are not sure if the statements are right composed you can use the PRINT Command to print our the composed commands for debugging.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

This is the output of the query:

Msg 213, Level 16, State 7, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
RESTORING DATABASE dataprova1
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "E:\dataprova1Data\dataprova1.mdf" failed with the operating system error 1008(An attempt was made to reference a token that does not exist.).
Msg 3156, Level 16, State 3, Line 1
File 'dataprova1ForRecovery_Data' cannot be restored to 'E:\dataprova1Data\dataprova1.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'D:\dataprova1Log\dataprova1_log.ldf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used.
Msg 3156, Level 16, State 3, Line 1
File 'dataprova1ForRecovery_Log' cannot be restored to 'D:\dataprova1Log\dataprova1_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 213, Level 16, State 7, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.

Thanks!!!

Kind Regards Gianpaolo

Restore a set of databases from a SQL2000 server to a SQL2005 server

I can restore databases one by one, setting .mdf and .ldf destination paths.

How can I restore all my Databases at the same time?

Thanks

G. Zanghi

You will either have restore or attach them one by one.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

In SQL2000 i have a script that permits me to restore, at the same time, a group of databases backed up with a maintenance plan.

In SQL2005 this script doesn't run. Do you know a similar one?

Restoring one by one it's an hard work....

|||COuld you send me over the script, perhaps I can try a transistion. My EMail is accessible through my profile.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Your Email doesn't run!

check this link: fengyu.china.com/source/sp_CSS_RestoreDir.sql

It's very similar to mine.

|||My Email works, you actually will have to remove the SPAMfuscator to make it work. Which error do you get ? If you are not sure if the statements are right composed you can use the PRINT Command to print our the composed commands for debugging.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

This is the output of the query:

Msg 213, Level 16, State 7, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
RESTORING DATABASE dataprova1
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "E:\dataprova1Data\dataprova1.mdf" failed with the operating system error 1008(An attempt was made to reference a token that does not exist.).
Msg 3156, Level 16, State 3, Line 1
File 'dataprova1ForRecovery_Data' cannot be restored to 'E:\dataprova1Data\dataprova1.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'D:\dataprova1Log\dataprova1_log.ldf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used.
Msg 3156, Level 16, State 3, Line 1
File 'dataprova1ForRecovery_Log' cannot be restored to 'D:\dataprova1Log\dataprova1_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 213, Level 16, State 7, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.

Thanks!!!

Kind Regards Gianpaolo