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

---