Error in restoring SSAS database

Hi,

getting this error on restoring an ssas database .abf file with a different database name.
Backup and restore errors: Restore under different DatabaseId/DatabaseName can not be done for a database with partitions with specific location.
(Microsoft.AnalysisServices)

Program Location:

at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)

The db from which the backup was created had its partition data outside of the cube specific folder
....\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data\XYZ.cub
That is the partition data was in the root folder ...\Data in the guid named folders.
Also tried changing the location for the partitions during the restore.

Is this an Analysis Services limitation?

Regards

That is correct.

The current limitation is: you cannot restore database with different name if you have partitions not in default location.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Error in restoring SQL Server 6.5 backup

Hi,
I am receiving an error when I try to do a restore of a backup from a
client. I am getting the following error:
"read on dump dump device 'e:\mssql\backup
\NAMEOFFILE' failed, vsn =1 return=1870835794 status = 2. Please consult
the errro log for more details. When I go to the error log I see the message
"dev_read_extent: Trying to read after end of data"
Can someone please tell me what the error means?
I am running 6.5.416 as my dbserver.
Thanks for your assistance,
KimHi
Google turns up nothing other than the obvious ones of corrupt dump file or
no disc space!
Are you both on the same service pack?
Are your devices the same size (or large enough!)?
John
"kimcmm" <kimcmm@.discussions.microsoft.com> wrote in message
news:2001E620-B617-4221-B921-C74BA0C9AB19@.microsoft.com...
> Hi,
> I am receiving an error when I try to do a restore of a backup from a
> client. I am getting the following error:
> "read on dump dump device 'e:\mssql\backup
> \NAMEOFFILE' failed, vsn =1 return=1870835794 status = 2. Please consult
> the errro log for more details. When I go to the error log I see the
> message
> "dev_read_extent: Trying to read after end of data"
> Can someone please tell me what the error means?
> I am running 6.5.416 as my dbserver.
> Thanks for your assistance,
> Kim|||Yeah, I checked google and I believe that this is a bad backup.My devices
that created the database on are large enough, otherwise I would have gotten
the error when the backup first attempted to run that says I don't have
enough space.
The backup proceeds about half way, then I get the error that I posted. The
database stays in a loading state until I run the DROP DATABASE command.
I will check with the client on the service pack.
"John Bell" wrote:
> Hi
> Google turns up nothing other than the obvious ones of corrupt dump file or
> no disc space!
> Are you both on the same service pack?
> Are your devices the same size (or large enough!)?
> John
> "kimcmm" <kimcmm@.discussions.microsoft.com> wrote in message
> news:2001E620-B617-4221-B921-C74BA0C9AB19@.microsoft.com...
> > Hi,
> > I am receiving an error when I try to do a restore of a backup from a
> > client. I am getting the following error:
> > "read on dump dump device 'e:\mssql\backup
> > \NAMEOFFILE' failed, vsn =1 return=1870835794 status = 2. Please consult
> > the errro log for more details. When I go to the error log I see the
> > message
> > "dev_read_extent: Trying to read after end of data"
> >
> > Can someone please tell me what the error means?
> > I am running 6.5.416 as my dbserver.
> >
> > Thanks for your assistance,
> > Kim
>
>

Error in restoring SQL Server 6.5 backup

Hi,
I am receiving an error when I try to do a restore of a backup from a
client. I am getting the following error:
"read on dump dump device 'e:\mssql\backup
\NAMEOFFILE' failed, vsn =1 return=1870835794 status = 2. Please consult
the errro log for more details. When I go to the error log I see the message
"dev_read_extent: Trying to read after end of data"
Can someone please tell me what the error means?
I am running 6.5.416 as my dbserver.
Thanks for your assistance,
Kim
Hi
Google turns up nothing other than the obvious ones of corrupt dump file or
no disc space!
Are you both on the same service pack?
Are your devices the same size (or large enough!)?
John
"kimcmm" <kimcmm@.discussions.microsoft.com> wrote in message
news:2001E620-B617-4221-B921-C74BA0C9AB19@.microsoft.com...
> Hi,
> I am receiving an error when I try to do a restore of a backup from a
> client. I am getting the following error:
> "read on dump dump device 'e:\mssql\backup
> \NAMEOFFILE' failed, vsn =1 return=1870835794 status = 2. Please consult
> the errro log for more details. When I go to the error log I see the
> message
> "dev_read_extent: Trying to read after end of data"
> Can someone please tell me what the error means?
> I am running 6.5.416 as my dbserver.
> Thanks for your assistance,
> Kim
|||Yeah, I checked google and I believe that this is a bad backup.My devices
that created the database on are large enough, otherwise I would have gotten
the error when the backup first attempted to run that says I don't have
enough space.
The backup proceeds about half way, then I get the error that I posted. The
database stays in a loading state until I run the DROP DATABASE command.
I will check with the client on the service pack.
"John Bell" wrote:

> Hi
> Google turns up nothing other than the obvious ones of corrupt dump file or
> no disc space!
> Are you both on the same service pack?
> Are your devices the same size (or large enough!)?
> John
> "kimcmm" <kimcmm@.discussions.microsoft.com> wrote in message
> news:2001E620-B617-4221-B921-C74BA0C9AB19@.microsoft.com...
>
>

Error in restoring database from .BAK file

Hi All,
I have one .BAK file. When I m trying to restore 'EMail_db.bak' file, I got following an error.
MS SQL-DMO (ODBC SQLState: 42000)
The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore operation. RESTORE DATBASE is terminating abnormally.
Plz help me...
Thnx in advance..
I suggest you try the RESTORE from Query Analyzer and post the restore command you executed.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Vikkas" <Vikas.jindal@.fqsltd.com> wrote in message news:87CD3985-BE3F-4B11-A594-6A3B0ECA86C3@.microsoft.com...
> Hi All,
> I have one .BAK file. When I m trying to restore 'EMail_db.bak' file, I got following an error.
> MS SQL-DMO (ODBC SQLState: 42000)
> The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore
operation. RESTORE DATBASE is terminating abnormally.
> Plz help me...
> Thnx in advance..
|||Hi
thnx for ur response.
i got this message in SQL Query Analyzer..
Server: Msg 3135, Level 16, State 2, Line 1
The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore operation.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
|||Hi,
Sorry i forgot to paste the Query
RESTORE DATABASE EMail
FROM DISK = 'D:\EMail_db.bak'
Error was
Server: Msg 3135, Level 16, State 2, Line 1
The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore operation.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Waiting for ur reply
|||That makes it easier... :-)
This file contains a transaction log backup, not a database backup. However, the file might contain several
backups. I suggest you use RESTORE HEADERONLY to see how many backups there is on this backup file, and then
use the FILE parameter to define which you want to restore. If you do not specify FILE, SQL Server assume the
first one.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Vikkas" <anonymous@.discussions.microsoft.com> wrote in message
news:03353991-A6AE-4600-A914-A0D3354CAB12@.microsoft.com...
> Hi,
> Sorry i forgot to paste the Query
> RESTORE DATABASE EMail
> FROM DISK = 'D:\EMail_db.bak'
> Error was
> Server: Msg 3135, Level 16, State 2, Line 1
> The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore
operation.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Waiting for ur reply
|||Hi,
Add on to Tibers post,
You have to identify the backup file which holds the Full database backup.
You have to restore the full database first using the below command
Restore database dbname from disk='filename' with NORECOVERY
(Norecovery clause allow you to restore the transaction log backup)
After the successful restore of database you have to go ahead with the
restore of transaction logs (Based on the suggestion from Tiber).
Restore log dbname from disk='filename' with norecovery
And in the final log file issue the command with recovery (Now the database
will open for read/write operations)
Restore log dbname from disk='filename' with RECOVERY
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:#Tgb9k0NEHA.2708@.TK2MSFTNGP10.phx.gbl...
> That makes it easier... :-)
> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the[vbcol=seagreen]
> first one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Vikkas" <anonymous@.discussions.microsoft.com> wrote in message
> news:03353991-A6AE-4600-A914-A0D3354CAB12@.microsoft.com...
cannot be used for this restore
> operation.
>
|||Again Thnx,
But let me know that can i restore from this transaction log backup file without having database.. Bcoz i don't have database and try to restore database from this transaction log backup file.
Vikkas
-------
This file contains a transaction log backup, not a database backup. However, the file might contain several
backups. I suggest you use RESTORE HEADERONLY to see how many backups there is on this backup file, and then
use the FILE parameter to define which you want to restore. If you do not specify FILE, SQL Server assume the
first one.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
|||No. A transaction log backup is only changes (since last transaction log backup). To be able to restore such,
you always have to first restore a database backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"vikkas" <anonymous@.discussions.microsoft.com> wrote in message
news:CDB0E09D-4EEB-4C46-A968-2FBD1B9F9D15@.microsoft.com...
> Again Thnx,
> But let me know that can i restore from this transaction log backup file without having database.. Bcoz i
don't have database and try to restore database from this transaction log backup file.
> Vikkas
> ----

> This file contains a transaction log backup, not a database backup. However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not specify FILE, SQL Server assume
the
> first one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
|||Hi Vikas,
No you cant restore the trasaction log file alone. Transaction log can be
restored only in below occasions:-
1. Destination database is standby to ur production database(destination
database must be in read only mode to acept the transaction log)
Other option is :-
1. Restore full database backup with NORECOVERY ( You should have a full
database backup file)
2. After the full database restore, Follow the Transaction log restore

> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the
> first one.
Tiber mentioned that ur backup file will be having more than one file, this
can be identified by issuing RESTORE HEADERONLY
with the command. If you have multiple files then you have to use
FILE=file_number during restore.
Thanks
Hari
MCDBA
"vikkas" <anonymous@.discussions.microsoft.com> wrote in message
news:CDB0E09D-4EEB-4C46-A968-2FBD1B9F9D15@.microsoft.com...
> Again Thnx,
> But let me know that can i restore from this transaction log backup file
without having database.. Bcoz i don't have database and try to restore
database from this transaction log backup file.
> Vikkas
> ----

> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the
> first one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>

Error in restoring database from .BAK file

Hi All,
I have one .BAK file. When I m trying to restore 'EMail_db.bak' file, I got
following an error.
MS SQL-DMO (ODBC SQLState: 42000)
The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and canno
t be used for this restore operation. RESTORE DATBASE is terminating abnorma
lly.
Plz help me...
Thnx in advance..I suggest you try the RESTORE from Query Analyzer and post the restore comma
nd you executed.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Vikkas" <Vikas.jindal@.fqsltd.com> wrote in message news:87CD3985-BE3F-4B11-A594-6A3B0ECA86C
3@.microsoft.com...
> Hi All,
> I have one .BAK file. When I m trying to restore 'EMail_db.bak' file, I go
t following an error.
> MS SQL-DMO (ODBC SQLState: 42000)
> The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be u
sed for this restore
operation. RESTORE DATBASE is terminating abnormally.
> Plz help me...
> Thnx in advance..|||Hi
thnx for ur response.
i got this message in SQL Query Analyzer..
Server: Msg 3135, Level 16, State 2, Line 1
The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and canno
t be used for this restore operation.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.|||Hi,
Sorry i forgot to paste the Query
RESTORE DATABASE EMail
FROM DISK = 'D:\EMail_db.bak'
Error was
Server: Msg 3135, Level 16, State 2, Line 1
The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and canno
t be used for this restore operation.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Waiting for ur reply|||That makes it easier... :-)
This file contains a transaction log backup, not a database backup. However,
the file might contain several
backups. I suggest you use RESTORE HEADERONLY to see how many backups there
is on this backup file, and then
use the FILE parameter to define which you want to restore. If you do not sp
ecify FILE, SQL Server assume the
first one.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Vikkas" <anonymous@.discussions.microsoft.com> wrote in message
news:03353991-A6AE-4600-A914-A0D3354CAB12@.microsoft.com...
> Hi,
> Sorry i forgot to paste the Query
> RESTORE DATABASE EMail
> FROM DISK = 'D:\EMail_db.bak'
> Error was
> Server: Msg 3135, Level 16, State 2, Line 1
> The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be u
sed for this restore
operation.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Waiting for ur reply|||Hi,
Add on to Tibers post,
You have to identify the backup file which holds the Full database backup.
You have to restore the full database first using the below command
Restore database dbname from disk='filename' with NORECOVERY
(Norecovery clause allow you to restore the transaction log backup)
After the successful restore of database you have to go ahead with the
restore of transaction logs (Based on the suggestion from Tiber).
Restore log dbname from disk='filename' with norecovery
And in the final log file issue the command with recovery (Now the database
will open for read/write operations)
Restore log dbname from disk='filename' with RECOVERY
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:#Tgb9k0NEHA.2708@.TK2MSFTNGP10.phx.gbl...
> That makes it easier... :-)
> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the
> first one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Vikkas" <anonymous@.discussions.microsoft.com> wrote in message
> news:03353991-A6AE-4600-A914-A0D3354CAB12@.microsoft.com...
cannot be used for this restore[vbcol=seagreen]
> operation.
>|||Again Thnx,
But let me know that can i restore from this transaction log backup file wit
hout having database.. Bcoz i don't have database and try to restore databas
e from this transaction log backup file.
Vikkas
----
---
This file contains a transaction log backup, not a database backup. However,
the file might contain several
backups. I suggest you use RESTORE HEADERONLY to see how many backups there
is on this backup file, and then
use the FILE parameter to define which you want to restore. If you do not sp
ecify FILE, SQL Server assume the
first one.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp|||No. A transaction log backup is only changes (since last transaction log bac
kup). To be able to restore such,
you always have to first restore a database backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"vikkas" <anonymous@.discussions.microsoft.com> wrote in message
news:CDB0E09D-4EEB-4C46-A968-2FBD1B9F9D15@.microsoft.com...
> Again Thnx,
> But let me know that can i restore from this transaction log backup file without h
aving database.. Bcoz i
don't have database and try to restore database from this transaction log backup file.[vbcol
=seagreen]
> Vikkas
> ----
--[/vbcol]
---
> This file contains a transaction log backup, not a database backup. Howeve
r, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups ther
e is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not specify
FILE, SQL Server assume
the
> first one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>|||Hi Vikas,
No you cant restore the trasaction log file alone. Transaction log can be
restored only in below occasions:-
1. Destination database is standby to ur production database(destination
database must be in read only mode to acept the transaction log)
Other option is :-
1. Restore full database backup with NORECOVERY ( You should have a full
database backup file)
2. After the full database restore, Follow the Transaction log restore
---
> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the
> first one.
Tiber mentioned that ur backup file will be having more than one file, this
can be identified by issuing RESTORE HEADERONLY
with the command. If you have multiple files then you have to use
FILE=file_number during restore.
Thanks
Hari
MCDBA
"vikkas" <anonymous@.discussions.microsoft.com> wrote in message
news:CDB0E09D-4EEB-4C46-A968-2FBD1B9F9D15@.microsoft.com...
> Again Thnx,
> But let me know that can i restore from this transaction log backup file
without having database.. Bcoz i don't have database and try to restore
database from this transaction log backup file.
> Vikkas
> ----
---
> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the
> first one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>

Error in restoring database from .BAK file

Hi All
I have one .BAK file. When I m trying to restore 'EMail_db.bak' file, I got following an error.
MS SQL-DMO (ODBC SQLState: 42000
The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore operation. RESTORE DATBASE is terminating abnormally
Plz help me..
Thnx in advance..I suggest you try the RESTORE from Query Analyzer and post the restore command you executed.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Vikkas" <Vikas.jindal@.fqsltd.com> wrote in message news:87CD3985-BE3F-4B11-A594-6A3B0ECA86C3@.microsoft.com...
> Hi All,
> I have one .BAK file. When I m trying to restore 'EMail_db.bak' file, I got following an error.
> MS SQL-DMO (ODBC SQLState: 42000)
> The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore
operation. RESTORE DATBASE is terminating abnormally.
> Plz help me...
> Thnx in advance..|||Hi
thnx for ur response
i got this message in SQL Query Analyzer.
Server: Msg 3135, Level 16, State 2, Line
The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore operation
Server: Msg 3013, Level 16, State 1, Line
RESTORE DATABASE is terminating abnormally|||Hi
Sorry i forgot to paste the Quer
RESTORE DATABASE EMai
FROM DISK = 'D:\EMail_db.bak
Error was
Server: Msg 3135, Level 16, State 2, Line
The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore operation
Server: Msg 3013, Level 16, State 1, Line
RESTORE DATABASE is terminating abnormally
Waiting for ur reply|||That makes it easier... :-)
This file contains a transaction log backup, not a database backup. However, the file might contain several
backups. I suggest you use RESTORE HEADERONLY to see how many backups there is on this backup file, and then
use the FILE parameter to define which you want to restore. If you do not specify FILE, SQL Server assume the
first one.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Vikkas" <anonymous@.discussions.microsoft.com> wrote in message
news:03353991-A6AE-4600-A914-A0D3354CAB12@.microsoft.com...
> Hi,
> Sorry i forgot to paste the Query
> RESTORE DATABASE EMail
> FROM DISK = 'D:\EMail_db.bak'
> Error was
> Server: Msg 3135, Level 16, State 2, Line 1
> The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and cannot be used for this restore
operation.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Waiting for ur reply|||Hi,
Add on to Tibers post,
You have to identify the backup file which holds the Full database backup.
You have to restore the full database first using the below command
Restore database dbname from disk='filename' with NORECOVERY
(Norecovery clause allow you to restore the transaction log backup)
After the successful restore of database you have to go ahead with the
restore of transaction logs (Based on the suggestion from Tiber).
Restore log dbname from disk='filename' with norecovery
And in the final log file issue the command with recovery (Now the database
will open for read/write operations)
Restore log dbname from disk='filename' with RECOVERY
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:#Tgb9k0NEHA.2708@.TK2MSFTNGP10.phx.gbl...
> That makes it easier... :-)
> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the
> first one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Vikkas" <anonymous@.discussions.microsoft.com> wrote in message
> news:03353991-A6AE-4600-A914-A0D3354CAB12@.microsoft.com...
> > Hi,
> >
> > Sorry i forgot to paste the Query
> >
> > RESTORE DATABASE EMail
> > FROM DISK = 'D:\EMail_db.bak'
> >
> > Error was
> >
> > Server: Msg 3135, Level 16, State 2, Line 1
> > The backup set in file 'D:\EMail_db.bak' was created by BACKUP LOG and
cannot be used for this restore
> operation.
> > Server: Msg 3013, Level 16, State 1, Line 1
> > RESTORE DATABASE is terminating abnormally.
> >
> > Waiting for ur reply
>|||No. A transaction log backup is only changes (since last transaction log backup). To be able to restore such,
you always have to first restore a database backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"vikkas" <anonymous@.discussions.microsoft.com> wrote in message
news:CDB0E09D-4EEB-4C46-A968-2FBD1B9F9D15@.microsoft.com...
> Again Thnx,
> But let me know that can i restore from this transaction log backup file without having database.. Bcoz i
don't have database and try to restore database from this transaction log backup file.
> Vikkas
> ----
---
> This file contains a transaction log backup, not a database backup. However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not specify FILE, SQL Server assume
the
> first one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>|||Hi Vikas,
No you cant restore the trasaction log file alone. Transaction log can be
restored only in below occasions:-
1. Destination database is standby to ur production database(destination
database must be in read only mode to acept the transaction log)
Other option is :-
1. Restore full database backup with NORECOVERY ( You should have a full
database backup file)
2. After the full database restore, Follow the Transaction log restore
---
> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the
> first one.
--
Tiber mentioned that ur backup file will be having more than one file, this
can be identified by issuing RESTORE HEADERONLY
with the command. If you have multiple files then you have to use
FILE=file_number during restore.
Thanks
Hari
MCDBA
"vikkas" <anonymous@.discussions.microsoft.com> wrote in message
news:CDB0E09D-4EEB-4C46-A968-2FBD1B9F9D15@.microsoft.com...
> Again Thnx,
> But let me know that can i restore from this transaction log backup file
without having database.. Bcoz i don't have database and try to restore
database from this transaction log backup file.
> Vikkas
> ----
---
> This file contains a transaction log backup, not a database backup.
However, the file might contain several
> backups. I suggest you use RESTORE HEADERONLY to see how many backups
there is on this backup file, and then
> use the FILE parameter to define which you want to restore. If you do not
specify FILE, SQL Server assume the
> first one.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>

Error in restoring database

Hi!
I would like to ask for help regarding the error message
that I always encounter when I'm trying to restore a
database:
ODBC SQLState: 42000
The database you are attempting to restore was backed up
under a diffferent sort order ID (205) than the one
currently running on this server (52), and at least one of
them is a non-binary sort order. Backup or restore
operation terminating abnormally.
Any ideas on how to solve to problem?
Thanks!
Best Regards,
JunYes, restore to SQL 2000 instead of SQL 7. SQL 7 can only restore databases
in the same sort order as SQL was installed in (run sp_helpsort to figure
this out). SQL 2000 can handle multiple collations. You can then transfer
the SQL 2000 database elsewhere.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Jun" <junpena@.chinasystems.com> wrote in message
news:10d501c3c6da$0aad5e10$a501280a@.phx.gbl...

quote:

---

> Hi!
> I would like to ask for help regarding the error message
> that I always encounter when I'm trying to restore a
> database:
> ODBC SQLState: 42000
> The database you are attempting to restore was backed up
> under a diffferent sort order ID (205) than the one
> currently running on this server (52), and at least one of
> them is a non-binary sort order. Backup or restore
> operation terminating abnormally.
> Any ideas on how to solve to problem?
> Thanks!
> Best Regards,
> Jun

---

error in restore script

I have attempted to create a script to do a backup and restore that would be useable for several different database servers. The script works fine on SQL 2000 but on SQL 7 I get the following error.

Server: Msg 3156, Level 16, State 2, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]The file 'C:\temp\test_log.ldf ' cannot be used by RESTORE. Consider using the WITH MOVE option to identify a valid location for the file.
Server: Msg 3013, Level 16, State 1, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.

The piece of code in question is:

EXEC('RESTORE DATABASE '+@.targetdb+'
FROM DISK = '''+@.sourcedb_backupdir+'''
WITH REPLACE, RECOVERY,
MOVE '''+@.source_restore_mdf_name+''' TO '''+@.target_restore_mdf_dir+''',
MOVE '''+@.source_restore_ldf_name+''' TO '''+@.target_restore_ldf_dir+'''')

Any help would be appreciated

The whole script (version SQL 7) is attached if that would help as well.I have gotten this message when I was restoring a dump that was from a different database. I see that you do use the MOVE, have you verified the physical and logical names? Instead of doing the EXEC, how about doing a PRINT, for debugging and see what the command is.|||This is what I get when I use the print statement:


RESTORE DATABASE test
FROM DISK = 'C:\temp\Northwind.bak'
WITH REPLACE, RECOVERY,
MOVE 'Northwind' TO 'c:\temp\test.mdf',
MOVE 'Northwind_log' TO 'C:\temp\test_log.ldf'

I get the following error in Query Analyzer:

Server: Msg 3156, Level 16, State 2, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]The file 'c:\temp\test.mdf' cannot be used by RESTORE. Consider using the WITH MOVE option to identify a valid location for the file.
Server: Msg 3013, Level 16, State 1, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.

When I look in the error log I get this error message:

2002-04-04 11:57:16.41 kernel BackupFileDesc::VerifyCreatability: Operating system error 32(The process cannot access the file because it is being used by another process.) during the creation/opening of physical device C:\temp\test_log.ldf

2002-04-04 13:28:15.00 kernel BackupFileDesc::VerifyCreatability: Operating system error 32(The process cannot access the file because it is being used by another process.) during the creation/opening of physical device c:\temp\test.mdf. 0

This error is confusing because before I start the restore I kill all users and put the db in single user mode.|||When you run the RESTORE command are you excuting it from MASTER? Is the logical names for database Northwind correct 'Northwind' for database file and 'Northwind_log' for transaction log? Also are the physical files for Test 'c:\temp\test.mdf' for data and 'C:\temp\test_log.ldf' for transaction log.
Just looking at the physical names they look like they would be the default names SQL Server generates <database name>_log.ldf and <database name>_data.mdf . The only thing is that if this is true then your physical name should be 'c:\temp\test_data.mdf'|||I am useing the master db.

If I run sp_helpdb for Northwind I get the following:

Northwind, 1, C:\MSSQL\DATA\northwnd.mdf, PRIMARY, 4864 KB, Unlimited, 10%, data only

Northwind_log, 2, C:\MSSQL7\DATA\northwnd.ldf, NULL, 1024 KB, Unlimited, 10%, log only

If I run sp_helpdb for test I get the following:

Northwind, 1, c:\temp\test.mdf, PRIMARY, 4864 KB, Unlimited, 10%, data only

Northwind_log, 2, C:\temp\test_log.ldf, NULL, 1024 KB, Unlimited, 10%, log only

When I set my variables I use the following:

CREATE TABLE #db_sysfiles
(
name VARCHAR(50),
filename VARCHAR(255),
dbname VARCHAR(50)
)

INSERT INTO #db_sysfiles EXEC ('SELECT a.name, a.filename, b.name FROM '+@.sourcedb+'..sysfiles a, master..sysdatabases b WHERE b.name = '''+@.sourcedb+'''')

INSERT INTO #db_sysfiles EXEC ('SELECT a.name, a.filename, b.name FROM '+@.targetdb+'..sysfiles a, master..sysdatabases b WHERE b.name = '''+@.targetdb+'''')

SELECT @.source_restore_mdf_name = RTRIM(name)
FROM #db_sysfiles
WHERE filename
LIKE '%.mdf%'
AND dbname = @.sourcedb

SELECT @.source_restore_ldf_name = RTRIM(name)
FROM #db_sysfiles
WHERE filename LIKE '%.ldf%'
AND dbname = @.sourcedb

SELECT @.target_restore_mdf_name = RTRIM(name)
FROM #db_sysfiles
WHERE filename
LIKE '%.mdf%'
AND dbname = @.targetdb

SELECT @.target_restore_ldf_name = RTRIM(name)
FROM #db_sysfiles
WHERE filename
LIKE '%.ldf%'
AND dbname = @.targetdb

SELECT @.target_restore_mdf_dir = RTRIM(filename)
FROM #db_sysfiles
WHERE filename
LIKE '%.mdf%'
AND dbname = @.targetdb

SELECT @.target_restore_ldf_dir = RTRIM(filename)
FROM #db_sysfiles
WHERE filename
LIKE '%.ldf%'
AND dbname = @.targetdb

SELECT @.source_restore_mdf_dir = RTRIM(filename)
FROM #db_sysfiles
WHERE filename
LIKE '%.mdf%'
AND dbname = @.sourcedb

SELECT @.source_restore_ldf_dir = RTRIM(filename)
FROM #db_sysfiles
WHERE filename
LIKE '%.ldf%'
AND dbname = @.sourcedb

Error in Restore Database

Dear all,
I get the following error when restore database :
Modify File encountered operating system error 112(There is not enough space
on the disk) while attempting to expand the physical file.
Can anyone tell me how I can overcome this problem ?
Thx.The error is very spcific - you don't have enough space on the disk.
You can delete some files in order to make more space on the disk or
restore the database to a different disk.
Adi
Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.|||Hello,
The Restore Database command will create a identical MDF and LDF which is
same as source database. So ensure that
you have enough space in physical hard drives you are going to restore.
Otherwise identify the right drives with space and
restore in that location.
Thanks
Hari
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:%23XphYUhPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough
> space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>|||Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>
Which part of "There is not enough space on the disk) while attempting
to expand the physical file" is unclear?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Error in Restore Database

Dear all,
I get the following error when restore database :
Modify File encountered operating system error 112(There is not enough space
on the disk) while attempting to expand the physical file.
Can anyone tell me how I can overcome this problem ?
Thx.
The error is very spcific - you don't have enough space on the disk.
You can delete some files in order to make more space on the disk or
restore the database to a different disk.
Adi
Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
|||Hello,
The Restore Database command will create a identical MDF and LDF which is
same as source database. So ensure that
you have enough space in physical hard drives you are going to restore.
Otherwise identify the right drives with space and
restore in that location.
Thanks
Hari
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:%23XphYUhPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough
> space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>
|||Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>
Which part of "There is not enough space on the disk) while attempting
to expand the physical file" is unclear?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Error in Restore Database

Dear all,
I get the following error when restore database :
Modify File encountered operating system error 112(There is not enough space
on the disk) while attempting to expand the physical file.
Can anyone tell me how I can overcome this problem ?
Thx.The error is very spcific - you don't have enough space on the disk.
You can delete some files in order to make more space on the disk or
restore the database to a different disk.
Adi
Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough spa
ce
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.|||Hello,
The Restore Database command will create a identical MDF and LDF which is
same as source database. So ensure that
you have enough space in physical hard drives you are going to restore.
Otherwise identify the right drives with space and
restore in that location.
Thanks
Hari
"Vensia" <vensia2000_nospam@.yahoo.com> wrote in message
news:%23XphYUhPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough
> space
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>|||Vensia wrote:
> Dear all,
> I get the following error when restore database :
> Modify File encountered operating system error 112(There is not enough spa
ce
> on the disk) while attempting to expand the physical file.
> Can anyone tell me how I can overcome this problem ?
> Thx.
>
Which part of "There is not enough space on the disk) while attempting
to expand the physical file" is unclear?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Error in restore

Dear Newsgroup,
I am using sql server 2000 over win 2000 server with service pack 4.
I have been given a back up of a database (I have tried both from T-SQL and
Enterprise Manager)
T-SQL
RESTORE FILELISTONLY
FROM DISK = 'c:\A.bck'
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf'
and as I try to restore I get the following error :
Server: Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'B'
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Would you kindly help me ''?
Thank you in advance,
YassYou need to specify the REPLACE option. This is needed when the target
database exists and the backup was created from a database with a different
name.
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf',
REPLACE
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Yass" <gol_e_yass@.yahoo.com> wrote in message
news:bv0tq4$1r58@.news.emirates.net.ae...
> Dear Newsgroup,
>
> I am using sql server 2000 over win 2000 server with service pack 4.
> I have been given a back up of a database (I have tried both from T-SQL
and
> Enterprise Manager)
> T-SQL
> RESTORE FILELISTONLY
> FROM DISK = 'c:\A.bck'
> RESTORE DATABASE B
> FROM DISK = 'c:\A.bck'
> WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
> MOVE 'A_Log' TO 'c:\test\B.ldf'
> and as I try to restore I get the following error :
> Server: Msg 3154, Level 16, State 2, Line 1
> The backup set holds a backup of a database other than the existing 'B'
> database.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Would you kindly help me ''?
> Thank you in advance,
> Yass
>
>
>

Error in restore

Dear Newsgroup,
I am using sql server 2000 over win 2000 server with service pack 4.
I have been given a back up of a database (I have tried both from T-SQL and
Enterprise Manager)
T-SQL
RESTORE FILELISTONLY
FROM DISK = 'c:\A.bck'
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf'
and as I try to restore I get the following error :
Server: Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'B'
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Would you kindly help me ''?
Thank you in advance,
YassYou need to specify the REPLACE option. This is needed when the target
database exists and the backup was created from a database with a different
name.
RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf',
REPLACE
Hope this helps.
Dan Guzman
SQL Server MVP
"Yass" <gol_e_yass@.yahoo.com> wrote in message
news:bv0tq4$1r58@.news.emirates.net.ae...

quote:

---

> Dear Newsgroup,
>
> I am using sql server 2000 over win 2000 server with service pack 4.
> I have been given a back up of a database (I have tried both from T-SQL

---

and

quote:

---

> Enterprise Manager)
> T-SQL
> RESTORE FILELISTONLY
> FROM DISK = 'c:\A.bck'
> RESTORE DATABASE B
> FROM DISK = 'c:\A.bck'
> WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
> MOVE 'A_Log' TO 'c:\test\B.ldf'
> and as I try to restore I get the following error :
> Server: Msg 3154, Level 16, State 2, Line 1
> The backup set holds a backup of a database other than the existing 'B'
> database.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Would you kindly help me ''?
> Thank you in advance,
> Yass
>
>
>

---

Error Icons displayed on parent objects with no or different children

I recently had to restore a database from backup and the restored
database had a different set of publications than the one I overwrote.
Since then, in EM, on the Replication Monitor object, Publishers, and
Servername objects as well as on the Agents and Snapshot Agents
objects, I see the little red X denoting an error. I have done
everything i can think of and more, following much advice given on this
group. I even turned replication off, deleted all publications, used
hilary cotter's script to clean up all the miscellaneous replication
tables/settings, etc. and restarted the server.
Everything seems to be working fine, but I would like to try to clean
up these "errors". Does anyone have any suggestions?
I am running SqlServer 8.00.2039 SP4 Standard Edition on Windows Server
2003 SP1
You will have to manually remove the replication jobs in msdb. Sometimes you
will get transitory error messages in EM, run sp_MSload_replication_status
to clear them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"troy" <troyblakely@.gmail.com> wrote in message
news:1125073355.972990.114690@.g47g2000cwa.googlegr oups.com...
> I recently had to restore a database from backup and the restored
> database had a different set of publications than the one I overwrote.
> Since then, in EM, on the Replication Monitor object, Publishers, and
> Servername objects as well as on the Agents and Snapshot Agents
> objects, I see the little red X denoting an error. I have done
> everything i can think of and more, following much advice given on this
> group. I even turned replication off, deleted all publications, used
> hilary cotter's script to clean up all the miscellaneous replication
> tables/settings, etc. and restarted the server.
> Everything seems to be working fine, but I would like to try to clean
> up these "errors". Does anyone have any suggestions?
> I am running SqlServer 8.00.2039 SP4 Standard Edition on Windows Server
> 2003 SP1
>