I receive a backup of a database, e.g. GImport. This backup is put on my
ftp-server and I need to restore the database on my databaseserver - the
GImport db is not currently on the server. Totally I need to perform the
following tasks:
1. Restore the database from the backup file. The name must be "GImport"
2. Move the restored files (db+log) to another location
3. Give the user myUsr read-access to all tables in the database
I have consulted BOL and I have made the following code
RESTORE FILELISTONLY
FROM DISK = 'c:\ftp\mp-back.dat'
RESTORE database GImport
FROM DISK = 'c:\ftp\mp-back.dat'
WITH NORECOVERY,
MOVE 'MP' TO 'D:\Data\mpgi.mdf',
MOVE 'MP_log' TO 'D:\Data\mpgi_log.ldf'
GO
It works fine ... kindda ... :( The database is created and the files are
moved to the correct location. But when I try to access the database via
Enterprise Mgr the database is "greyed out" and it says (Loading) besides
the name.
When running the code in QU I get the result:
Processed 132032 pages for database 'GImport', file 'MP' on file 1.
Processed 1 pages for database 'GeusImport', file 'MP_log' on file 1.
RESTORE DATABASE successfully processed 132033 pages in 46.329 seconds
(23.346 MB/sec).
... but the database remains grey and inaccessible
Do I need something else in my code above or is the problem caused by
something else?
Thanks,
:o)
--
Jesper Stocholm
http://stocholm.dkSpecify RECOVERY instead of NORECOVERY.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jesper Stocholm" <j@.stocholm.invalid> wrote in message
news:Xns96C5541FC45FAstocholmdk@.207.46.248.16...
>I receive a backup of a database, e.g. GImport. This backup is put on my
> ftp-server and I need to restore the database on my databaseserver - the
> GImport db is not currently on the server. Totally I need to perform the
> following tasks:
> 1. Restore the database from the backup file. The name must be "GImport"
> 2. Move the restored files (db+log) to another location
> 3. Give the user myUsr read-access to all tables in the database
> I have consulted BOL and I have made the following code
> RESTORE FILELISTONLY
> FROM DISK = 'c:\ftp\mp-back.dat'
> RESTORE database GImport
> FROM DISK = 'c:\ftp\mp-back.dat'
> WITH NORECOVERY,
> MOVE 'MP' TO 'D:\Data\mpgi.mdf',
> MOVE 'MP_log' TO 'D:\Data\mpgi_log.ldf'
> GO
> It works fine ... kindda ... :( The database is created and the files are
> moved to the correct location. But when I try to access the database via
> Enterprise Mgr the database is "greyed out" and it says (Loading) besides
> the name.
> When running the code in QU I get the result:
> Processed 132032 pages for database 'GImport', file 'MP' on file 1.
> Processed 1 pages for database 'GeusImport', file 'MP_log' on file 1.
> RESTORE DATABASE successfully processed 132033 pages in 46.329 seconds
> (23.346 MB/sec).
> ... but the database remains grey and inaccessible
> Do I need something else in my code above or is the problem caused by
> something else?
> Thanks,
> :o)
> --
> Jesper Stocholm
> http://stocholm.dk|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
news:uT0ZS74rFHA.2604@.TK2MSFTNGP14.phx.gbl:
> Specify RECOVERY instead of NORECOVERY.
>
Yes! it works ... thanks a lot for your prompt reply :o)
The last task I need to perform is to grant a sql-login on my
databaseserver select access on all tables in the newly restored database.
However if I look in BOL it seems that it is only possible to grant access
to a object like a table or view. Is this correct?
Thanks again,
--
Jesper Stocholm
http://stocholm.dk
Japo stole sælges - http://japoarmstole.stocholm.dk|||Check out the db_datareader database group. It will grant SELECT permissions on all objects.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jesper Stocholm" <j@.stocholm.invalid> wrote in message
news:Xns96C561B32326Fstocholmdk@.207.46.248.16...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> news:uT0ZS74rFHA.2604@.TK2MSFTNGP14.phx.gbl:
>> Specify RECOVERY instead of NORECOVERY.
> Yes! it works ... thanks a lot for your prompt reply :o)
> The last task I need to perform is to grant a sql-login on my
> databaseserver select access on all tables in the newly restored database.
> However if I look in BOL it seems that it is only possible to grant access
> to a object like a table or view. Is this correct?
> Thanks again,
> --
> Jesper Stocholm
> http://stocholm.dk
> Japo stole sælges - http://japoarmstole.stocholm.dk
Showing posts with label receive. Show all posts
Showing posts with label receive. Show all posts
Monday, March 26, 2012
Restore database with SP
I receive a backup of a database, e.g. GImport. This backup is put on my
ftp-server and I need to restore the database on my databaseserver - the
GImport db is not currently on the server. Totally I need to perform the
following tasks:
1. Restore the database from the backup file. The name must be "GImport"
2. Move the restored files (db+log) to another location
3. Give the user myUsr read-access to all tables in the database
I have consulted BOL and I have made the following code
RESTORE FILELISTONLY
FROM DISK = 'c:\ftp\mp-back.dat'
RESTORE database GImport
FROM DISK = 'c:\ftp\mp-back.dat'
WITH NORECOVERY,
MOVE 'MP' TO 'D:\Data\mpgi.mdf',
MOVE 'MP_log' TO 'D:\Data\mpgi_log.ldf'
GO
It works fine ... kindda ...
The database is created and the files are
moved to the correct location. But when I try to access the database via
Enterprise Mgr the database is "greyed out" and it says (Loading) besides
the name.
When running the code in QU I get the result:
Processed 132032 pages for database 'GImport', file 'MP' on file 1.
Processed 1 pages for database 'GeusImport', file 'MP_log' on file 1.
RESTORE DATABASE successfully processed 132033 pages in 46.329 seconds
(23.346 MB/sec).
... but the database remains grey and inaccessible
Do I need something else in my code above or is the problem caused by
something else?
Thanks,
:o)
Jesper Stocholm
http://stocholm.dk
Specify RECOVERY instead of NORECOVERY.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jesper Stocholm" <j@.stocholm.invalid> wrote in message
news:Xns96C5541FC45FAstocholmdk@.207.46.248.16...
>I receive a backup of a database, e.g. GImport. This backup is put on my
> ftp-server and I need to restore the database on my databaseserver - the
> GImport db is not currently on the server. Totally I need to perform the
> following tasks:
> 1. Restore the database from the backup file. The name must be "GImport"
> 2. Move the restored files (db+log) to another location
> 3. Give the user myUsr read-access to all tables in the database
> I have consulted BOL and I have made the following code
> RESTORE FILELISTONLY
> FROM DISK = 'c:\ftp\mp-back.dat'
> RESTORE database GImport
> FROM DISK = 'c:\ftp\mp-back.dat'
> WITH NORECOVERY,
> MOVE 'MP' TO 'D:\Data\mpgi.mdf',
> MOVE 'MP_log' TO 'D:\Data\mpgi_log.ldf'
> GO
> It works fine ... kindda ... The database is created and the files are
> moved to the correct location. But when I try to access the database via
> Enterprise Mgr the database is "greyed out" and it says (Loading) besides
> the name.
> When running the code in QU I get the result:
> Processed 132032 pages for database 'GImport', file 'MP' on file 1.
> Processed 1 pages for database 'GeusImport', file 'MP_log' on file 1.
> RESTORE DATABASE successfully processed 132033 pages in 46.329 seconds
> (23.346 MB/sec).
> ... but the database remains grey and inaccessible
> Do I need something else in my code above or is the problem caused by
> something else?
> Thanks,
> :o)
> --
> Jesper Stocholm
> http://stocholm.dk
|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
news:uT0ZS74rFHA.2604@.TK2MSFTNGP14.phx.gbl:
> Specify RECOVERY instead of NORECOVERY.
>
Yes! it works ... thanks a lot for your prompt reply :o)
The last task I need to perform is to grant a sql-login on my
databaseserver select access on all tables in the newly restored database.
However if I look in BOL it seems that it is only possible to grant access
to a object like a table or view. Is this correct?
Thanks again,
Jesper Stocholm
http://stocholm.dk
Japo stole slges - http://japoarmstole.stocholm.dk
|||Check out the db_datareader database group. It will grant SELECT permissions on all objects.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jesper Stocholm" <j@.stocholm.invalid> wrote in message
news:Xns96C561B32326Fstocholmdk@.207.46.248.16...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> news:uT0ZS74rFHA.2604@.TK2MSFTNGP14.phx.gbl:
>
> Yes! it works ... thanks a lot for your prompt reply :o)
> The last task I need to perform is to grant a sql-login on my
> databaseserver select access on all tables in the newly restored database.
> However if I look in BOL it seems that it is only possible to grant access
> to a object like a table or view. Is this correct?
> Thanks again,
> --
> Jesper Stocholm
> http://stocholm.dk
> Japo stole slges - http://japoarmstole.stocholm.dk
sql
ftp-server and I need to restore the database on my databaseserver - the
GImport db is not currently on the server. Totally I need to perform the
following tasks:
1. Restore the database from the backup file. The name must be "GImport"
2. Move the restored files (db+log) to another location
3. Give the user myUsr read-access to all tables in the database
I have consulted BOL and I have made the following code
RESTORE FILELISTONLY
FROM DISK = 'c:\ftp\mp-back.dat'
RESTORE database GImport
FROM DISK = 'c:\ftp\mp-back.dat'
WITH NORECOVERY,
MOVE 'MP' TO 'D:\Data\mpgi.mdf',
MOVE 'MP_log' TO 'D:\Data\mpgi_log.ldf'
GO
It works fine ... kindda ...
The database is created and the files aremoved to the correct location. But when I try to access the database via
Enterprise Mgr the database is "greyed out" and it says (Loading) besides
the name.
When running the code in QU I get the result:
Processed 132032 pages for database 'GImport', file 'MP' on file 1.
Processed 1 pages for database 'GeusImport', file 'MP_log' on file 1.
RESTORE DATABASE successfully processed 132033 pages in 46.329 seconds
(23.346 MB/sec).
... but the database remains grey and inaccessible
Do I need something else in my code above or is the problem caused by
something else?
Thanks,
:o)
Jesper Stocholm
http://stocholm.dk
Specify RECOVERY instead of NORECOVERY.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jesper Stocholm" <j@.stocholm.invalid> wrote in message
news:Xns96C5541FC45FAstocholmdk@.207.46.248.16...
>I receive a backup of a database, e.g. GImport. This backup is put on my
> ftp-server and I need to restore the database on my databaseserver - the
> GImport db is not currently on the server. Totally I need to perform the
> following tasks:
> 1. Restore the database from the backup file. The name must be "GImport"
> 2. Move the restored files (db+log) to another location
> 3. Give the user myUsr read-access to all tables in the database
> I have consulted BOL and I have made the following code
> RESTORE FILELISTONLY
> FROM DISK = 'c:\ftp\mp-back.dat'
> RESTORE database GImport
> FROM DISK = 'c:\ftp\mp-back.dat'
> WITH NORECOVERY,
> MOVE 'MP' TO 'D:\Data\mpgi.mdf',
> MOVE 'MP_log' TO 'D:\Data\mpgi_log.ldf'
> GO
> It works fine ... kindda ...
The database is created and the files are> moved to the correct location. But when I try to access the database via
> Enterprise Mgr the database is "greyed out" and it says (Loading) besides
> the name.
> When running the code in QU I get the result:
> Processed 132032 pages for database 'GImport', file 'MP' on file 1.
> Processed 1 pages for database 'GeusImport', file 'MP_log' on file 1.
> RESTORE DATABASE successfully processed 132033 pages in 46.329 seconds
> (23.346 MB/sec).
> ... but the database remains grey and inaccessible
> Do I need something else in my code above or is the problem caused by
> something else?
> Thanks,
> :o)
> --
> Jesper Stocholm
> http://stocholm.dk
|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
news:uT0ZS74rFHA.2604@.TK2MSFTNGP14.phx.gbl:
> Specify RECOVERY instead of NORECOVERY.
>
Yes! it works ... thanks a lot for your prompt reply :o)
The last task I need to perform is to grant a sql-login on my
databaseserver select access on all tables in the newly restored database.
However if I look in BOL it seems that it is only possible to grant access
to a object like a table or view. Is this correct?
Thanks again,
Jesper Stocholm
http://stocholm.dk
Japo stole slges - http://japoarmstole.stocholm.dk
|||Check out the db_datareader database group. It will grant SELECT permissions on all objects.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jesper Stocholm" <j@.stocholm.invalid> wrote in message
news:Xns96C561B32326Fstocholmdk@.207.46.248.16...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> news:uT0ZS74rFHA.2604@.TK2MSFTNGP14.phx.gbl:
>
> Yes! it works ... thanks a lot for your prompt reply :o)
> The last task I need to perform is to grant a sql-login on my
> databaseserver select access on all tables in the newly restored database.
> However if I look in BOL it seems that it is only possible to grant access
> to a object like a table or view. Is this correct?
> Thanks again,
> --
> Jesper Stocholm
> http://stocholm.dk
> Japo stole slges - http://japoarmstole.stocholm.dk
sql
Restore database with SP
I receive a backup of a database, e.g. GImport. This backup is put on my
ftp-server and I need to restore the database on my databaseserver - the
GImport db is not currently on the server. Totally I need to perform the
following tasks:
1. Restore the database from the backup file. The name must be "GImport"
2. Move the restored files (db+log) to another location
3. Give the user myUsr read-access to all tables in the database
I have consulted BOL and I have made the following code
RESTORE FILELISTONLY
FROM DISK = 'c:\ftp\mp-back.dat'
RESTORE database GImport
FROM DISK = 'c:\ftp\mp-back.dat'
WITH NORECOVERY,
MOVE 'MP' TO 'D:\Data\mpgi.mdf',
MOVE 'MP_log' TO 'D:\Data\mpgi_log.ldf'
GO
It works fine ... kindda ... The database is created and the files are
moved to the correct location. But when I try to access the database via
Enterprise Mgr the database is "greyed out" and it says (Loading) besides
the name.
When running the code in QU I get the result:
Processed 132032 pages for database 'GImport', file 'MP' on file 1.
Processed 1 pages for database 'GeusImport', file 'MP_log' on file 1.
RESTORE DATABASE successfully processed 132033 pages in 46.329 seconds
(23.346 MB/sec).
... but the database remains grey and inaccessible
Do I need something else in my code above or is the problem caused by
something else?
Thanks,
:o)
Jesper Stocholm
http://stocholm.dkSpecify RECOVERY instead of NORECOVERY.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jesper Stocholm" <j@.stocholm.invalid> wrote in message
news:Xns96C5541FC45FAstocholmdk@.207.46.248.16...
>I receive a backup of a database, e.g. GImport. This backup is put on my
> ftp-server and I need to restore the database on my databaseserver - the
> GImport db is not currently on the server. Totally I need to perform the
> following tasks:
> 1. Restore the database from the backup file. The name must be "GImport"
> 2. Move the restored files (db+log) to another location
> 3. Give the user myUsr read-access to all tables in the database
> I have consulted BOL and I have made the following code
> RESTORE FILELISTONLY
> FROM DISK = 'c:\ftp\mp-back.dat'
> RESTORE database GImport
> FROM DISK = 'c:\ftp\mp-back.dat'
> WITH NORECOVERY,
> MOVE 'MP' TO 'D:\Data\mpgi.mdf',
> MOVE 'MP_log' TO 'D:\Data\mpgi_log.ldf'
> GO
> It works fine ... kindda ... The database is created and the files are
> moved to the correct location. But when I try to access the database via
> Enterprise Mgr the database is "greyed out" and it says (Loading) besides
> the name.
> When running the code in QU I get the result:
> Processed 132032 pages for database 'GImport', file 'MP' on file 1.
> Processed 1 pages for database 'GeusImport', file 'MP_log' on file 1.
> RESTORE DATABASE successfully processed 132033 pages in 46.329 seconds
> (23.346 MB/sec).
> ... but the database remains grey and inaccessible
> Do I need something else in my code above or is the problem caused by
> something else?
> Thanks,
> :o)
> --
> Jesper Stocholm
> http://stocholm.dk|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
news:uT0ZS74rFHA.2604@.TK2MSFTNGP14.phx.gbl:
> Specify RECOVERY instead of NORECOVERY.
>
Yes! it works ... thanks a lot for your prompt reply :o)
The last task I need to perform is to grant a sql-login on my
databaseserver select access on all tables in the newly restored database.
However if I look in BOL it seems that it is only possible to grant access
to a object like a table or view. Is this correct?
Thanks again,
Jesper Stocholm
http://stocholm.dk
Japo stole slges - http://japoarmstole.stocholm.dk|||Check out the db_datareader database group. It will grant SELECT permissions
on all objects.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jesper Stocholm" <j@.stocholm.invalid> wrote in message
news:Xns96C561B32326Fstocholmdk@.207.46.248.16...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> news:uT0ZS74rFHA.2604@.TK2MSFTNGP14.phx.gbl:
>
> Yes! it works ... thanks a lot for your prompt reply :o)
> The last task I need to perform is to grant a sql-login on my
> databaseserver select access on all tables in the newly restored database.
> However if I look in BOL it seems that it is only possible to grant access
> to a object like a table or view. Is this correct?
> Thanks again,
> --
> Jesper Stocholm
> http://stocholm.dk
> Japo stole slges - http://japoarmstole.stocholm.dk
ftp-server and I need to restore the database on my databaseserver - the
GImport db is not currently on the server. Totally I need to perform the
following tasks:
1. Restore the database from the backup file. The name must be "GImport"
2. Move the restored files (db+log) to another location
3. Give the user myUsr read-access to all tables in the database
I have consulted BOL and I have made the following code
RESTORE FILELISTONLY
FROM DISK = 'c:\ftp\mp-back.dat'
RESTORE database GImport
FROM DISK = 'c:\ftp\mp-back.dat'
WITH NORECOVERY,
MOVE 'MP' TO 'D:\Data\mpgi.mdf',
MOVE 'MP_log' TO 'D:\Data\mpgi_log.ldf'
GO
It works fine ... kindda ...
The database is created and the files aremoved to the correct location. But when I try to access the database via
Enterprise Mgr the database is "greyed out" and it says (Loading) besides
the name.
When running the code in QU I get the result:
Processed 132032 pages for database 'GImport', file 'MP' on file 1.
Processed 1 pages for database 'GeusImport', file 'MP_log' on file 1.
RESTORE DATABASE successfully processed 132033 pages in 46.329 seconds
(23.346 MB/sec).
... but the database remains grey and inaccessible
Do I need something else in my code above or is the problem caused by
something else?
Thanks,
:o)
Jesper Stocholm
http://stocholm.dkSpecify RECOVERY instead of NORECOVERY.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jesper Stocholm" <j@.stocholm.invalid> wrote in message
news:Xns96C5541FC45FAstocholmdk@.207.46.248.16...
>I receive a backup of a database, e.g. GImport. This backup is put on my
> ftp-server and I need to restore the database on my databaseserver - the
> GImport db is not currently on the server. Totally I need to perform the
> following tasks:
> 1. Restore the database from the backup file. The name must be "GImport"
> 2. Move the restored files (db+log) to another location
> 3. Give the user myUsr read-access to all tables in the database
> I have consulted BOL and I have made the following code
> RESTORE FILELISTONLY
> FROM DISK = 'c:\ftp\mp-back.dat'
> RESTORE database GImport
> FROM DISK = 'c:\ftp\mp-back.dat'
> WITH NORECOVERY,
> MOVE 'MP' TO 'D:\Data\mpgi.mdf',
> MOVE 'MP_log' TO 'D:\Data\mpgi_log.ldf'
> GO
> It works fine ... kindda ...
The database is created and the files are> moved to the correct location. But when I try to access the database via
> Enterprise Mgr the database is "greyed out" and it says (Loading) besides
> the name.
> When running the code in QU I get the result:
> Processed 132032 pages for database 'GImport', file 'MP' on file 1.
> Processed 1 pages for database 'GeusImport', file 'MP_log' on file 1.
> RESTORE DATABASE successfully processed 132033 pages in 46.329 seconds
> (23.346 MB/sec).
> ... but the database remains grey and inaccessible
> Do I need something else in my code above or is the problem caused by
> something else?
> Thanks,
> :o)
> --
> Jesper Stocholm
> http://stocholm.dk|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
news:uT0ZS74rFHA.2604@.TK2MSFTNGP14.phx.gbl:
> Specify RECOVERY instead of NORECOVERY.
>
Yes! it works ... thanks a lot for your prompt reply :o)
The last task I need to perform is to grant a sql-login on my
databaseserver select access on all tables in the newly restored database.
However if I look in BOL it seems that it is only possible to grant access
to a object like a table or view. Is this correct?
Thanks again,
Jesper Stocholm
http://stocholm.dk
Japo stole slges - http://japoarmstole.stocholm.dk|||Check out the db_datareader database group. It will grant SELECT permissions
on all objects.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jesper Stocholm" <j@.stocholm.invalid> wrote in message
news:Xns96C561B32326Fstocholmdk@.207.46.248.16...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> news:uT0ZS74rFHA.2604@.TK2MSFTNGP14.phx.gbl:
>
> Yes! it works ... thanks a lot for your prompt reply :o)
> The last task I need to perform is to grant a sql-login on my
> databaseserver select access on all tables in the newly restored database.
> However if I look in BOL it seems that it is only possible to grant access
> to a object like a table or view. Is this correct?
> Thanks again,
> --
> Jesper Stocholm
> http://stocholm.dk
> Japo stole slges - http://japoarmstole.stocholm.dk
Tuesday, March 20, 2012
Restore Database
When I try to restore my database receive the message:
"The media set for database 'MyDB' has 2 family members, but only 1 are provided. All members must be provided."
I don't find the other dump device.
Do I can restore anyway??
thanks,
Ericson.I am having a similar problem with a backup of a database that has been successfully running the past two months. Suddenly this weekend, the same error message started appearing for me?
Any ideas?|||Originally posted by acg_ray
I am having a similar problem with a backup of a database that has been successfully running the past two months. Suddenly this weekend, the same error message started appearing for me?
Any ideas?
I have no succes to restore my database.
I has create the database again e loses the data.|||One of my customers reported the same problem that you guys were having. I found in his case that he had spanned his backup across multiple files when he made it.
So, in the Database Backup Destination box, he had multiple entries before backing up. Then when he went to restore the database to another machine, he was unaware that he should have had multiple files. This restore file was coded to tell Sql Server that it was only one part of the backup.
In his case, I had him go back to the server and create only one backup file.|||Are you using tape backup? It may be that your database backup run across two tapes and it's looking for another backup media.
"The media set for database 'MyDB' has 2 family members, but only 1 are provided. All members must be provided."
I don't find the other dump device.
Do I can restore anyway??
thanks,
Ericson.I am having a similar problem with a backup of a database that has been successfully running the past two months. Suddenly this weekend, the same error message started appearing for me?
Any ideas?|||Originally posted by acg_ray
I am having a similar problem with a backup of a database that has been successfully running the past two months. Suddenly this weekend, the same error message started appearing for me?
Any ideas?
I have no succes to restore my database.
I has create the database again e loses the data.|||One of my customers reported the same problem that you guys were having. I found in his case that he had spanned his backup across multiple files when he made it.
So, in the Database Backup Destination box, he had multiple entries before backing up. Then when he went to restore the database to another machine, he was unaware that he should have had multiple files. This restore file was coded to tell Sql Server that it was only one part of the backup.
In his case, I had him go back to the server and create only one backup file.|||Are you using tape backup? It may be that your database backup run across two tapes and it's looking for another backup media.
Subscribe to:
Posts (Atom)