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
>
Showing posts with label odbc. Show all posts
Showing posts with label odbc. Show all posts
Monday, March 19, 2012
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
>
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
>
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
>
Sunday, March 11, 2012
Error in ODBC Connetion
I had in a customer a ODBC connection to the database sql
in which I modified the client configurations the
connection I took off the option to determine door
dynamicly and placed the 1433 but it gave error and after
this exactly placing again to determine door dynamicly it
gives always error and it does not function i remember
that before this it was to function perfectly. The error
is:
Error in Connection:
SQLState: ' 01000 '
Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
Error in Connection:
SQLState: ' 08001 ' Error in the SQL Sever: 17 [
Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
Server does not exist or the access was refused the
computer in cause is with all the right definitions of
net, has access to the server... Please help Me! .J=E1 tentaste fazer um ODBCping? J=E1 verificas-te as permiss=F5es?
>--Original Message--
>I had in a customer a ODBC connection to the database sql >in which I modified the client configurations the >connection I took off the option to determine door >dynamicly and placed the 1433 but it gave error and after >this exactly placing again to determine door dynamicly it >gives always error and it does not function i remember >that before this it was to function perfectly. The error >is: >Error in Connection: >SQLState: ' 01000 ' >Error in the SQL Server: 10061 [ Microsoft][ODBC SQL >Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
>Error in Connection:
>SQLState: ' 08001 ' Error in the SQL Sever: 17 [ >Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL >Server does not exist or the access was refused the >computer in cause is with all the right definitions of >net, has access to the server... Please help Me! .
>.
>
in which I modified the client configurations the
connection I took off the option to determine door
dynamicly and placed the 1433 but it gave error and after
this exactly placing again to determine door dynamicly it
gives always error and it does not function i remember
that before this it was to function perfectly. The error
is:
Error in Connection:
SQLState: ' 01000 '
Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
Error in Connection:
SQLState: ' 08001 ' Error in the SQL Sever: 17 [
Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
Server does not exist or the access was refused the
computer in cause is with all the right definitions of
net, has access to the server... Please help Me! .J=E1 tentaste fazer um ODBCping? J=E1 verificas-te as permiss=F5es?
>--Original Message--
>I had in a customer a ODBC connection to the database sql >in which I modified the client configurations the >connection I took off the option to determine door >dynamicly and placed the 1433 but it gave error and after >this exactly placing again to determine door dynamicly it >gives always error and it does not function i remember >that before this it was to function perfectly. The error >is: >Error in Connection: >SQLState: ' 01000 ' >Error in the SQL Server: 10061 [ Microsoft][ODBC SQL >Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
>Error in Connection:
>SQLState: ' 08001 ' Error in the SQL Sever: 17 [ >Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL >Server does not exist or the access was refused the >computer in cause is with all the right definitions of >net, has access to the server... Please help Me! .
>.
>
Error in ODBC Connection HELP
I had in a customer a ODBC connection to the database sql
in which I modified the client configurations the
connection I took off the option to determine door
dynamicly and placed the 1433 but it gave error and after
this exactly placing again to determine door dynamicly it
gives always error and it does not function i remember
that before this it was to function perfectly. The error
is:
Error in Connection:
SQLState: ' 01000 '
Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
Error in Connection:
SQLState: ' 08001 ' Error in the SQL Sever: 17 [
Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
Server does not exist or the access was refused the
computer in cause is with all the right definitions of
net, has access to the server... Please help Me! .
Hi Nuno,
first of all be sure that you don't have network generic problems, using for
example the dos PING command or TRACERT.
Then I'd reinstall MDAC on client machine (if you've to connect to SQL
Server 7.00 install MDAC 2.5, for SQL 2000 MDAC 2.6SP2), reboot the client
and try again deleting the old DSN and recreating a newest one.
Very important is checking the TCP port is your server listening on (check
the server network utility on your server machine) and the TCP port is your
server transmetting (check the client network utility on your client
machine): they must be identical.
Finally check the authentication mode on your sql server: it must be the
same of the specified into your DSN configuration.
Hope it helps, regards
Riccardo Piccini
Supporto Software
EDP SERVICE SRL
"Nuno Pereira" <n.pereira@.desis.pt> ha scritto nel messaggio
news:17df301c42221$d6cab310$a001280a@.phx.gbl...
> I had in a customer a ODBC connection to the database sql
> in which I modified the client configurations the
> connection I took off the option to determine door
> dynamicly and placed the 1433 but it gave error and after
> this exactly placing again to determine door dynamicly it
> gives always error and it does not function i remember
> that before this it was to function perfectly. The error
> is:
> Error in Connection:
> SQLState: ' 01000 '
> Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
> Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
> Error in Connection:
> SQLState: ' 08001 ' Error in the SQL Sever: 17 [
> Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
> Server does not exist or the access was refused the
> computer in cause is with all the right definitions of
> net, has access to the server... Please help Me! .
in which I modified the client configurations the
connection I took off the option to determine door
dynamicly and placed the 1433 but it gave error and after
this exactly placing again to determine door dynamicly it
gives always error and it does not function i remember
that before this it was to function perfectly. The error
is:
Error in Connection:
SQLState: ' 01000 '
Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
Error in Connection:
SQLState: ' 08001 ' Error in the SQL Sever: 17 [
Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
Server does not exist or the access was refused the
computer in cause is with all the right definitions of
net, has access to the server... Please help Me! .
Hi Nuno,
first of all be sure that you don't have network generic problems, using for
example the dos PING command or TRACERT.
Then I'd reinstall MDAC on client machine (if you've to connect to SQL
Server 7.00 install MDAC 2.5, for SQL 2000 MDAC 2.6SP2), reboot the client
and try again deleting the old DSN and recreating a newest one.
Very important is checking the TCP port is your server listening on (check
the server network utility on your server machine) and the TCP port is your
server transmetting (check the client network utility on your client
machine): they must be identical.
Finally check the authentication mode on your sql server: it must be the
same of the specified into your DSN configuration.
Hope it helps, regards
Riccardo Piccini
Supporto Software
EDP SERVICE SRL
"Nuno Pereira" <n.pereira@.desis.pt> ha scritto nel messaggio
news:17df301c42221$d6cab310$a001280a@.phx.gbl...
> I had in a customer a ODBC connection to the database sql
> in which I modified the client configurations the
> connection I took off the option to determine door
> dynamicly and placed the 1433 but it gave error and after
> this exactly placing again to determine door dynamicly it
> gives always error and it does not function i remember
> that before this it was to function perfectly. The error
> is:
> Error in Connection:
> SQLState: ' 01000 '
> Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
> Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
> Error in Connection:
> SQLState: ' 08001 ' Error in the SQL Sever: 17 [
> Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
> Server does not exist or the access was refused the
> computer in cause is with all the right definitions of
> net, has access to the server... Please help Me! .
Error in ODBC Connection HELP
I had in a customer a ODBC connection to the database sql
in which I modified the client configurations the
connection I took off the option to determine door
dynamicly and placed the 1433 but it gave error and after
this exactly placing again to determine door dynamicly it
gives always error and it does not function i remember
that before this it was to function perfectly. The error
is:
Error in Connection:
SQLState: ' 01000 '
Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
Error in Connection:
SQLState: ' 08001 ' Error in the SQL Sever: 17 [
Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
Server does not exist or the access was refused the
computer in cause is with all the right definitions of
net, has access to the server... Please help Me! .Hi Nuno,
first of all be sure that you don't have network generic problems, using for
example the dos PING command or TRACERT.
Then I'd reinstall MDAC on client machine (if you've to connect to SQL
Server 7.00 install MDAC 2.5, for SQL 2000 MDAC 2.6SP2), reboot the client
and try again deleting the old DSN and recreating a newest one.
Very important is checking the TCP port is your server listening on (check
the server network utility on your server machine) and the TCP port is your
server transmetting (check the client network utility on your client
machine): they must be identical.
Finally check the authentication mode on your sql server: it must be the
same of the specified into your DSN configuration.
Hope it helps, regards
Riccardo Piccini
Supporto Software
EDP SERVICE SRL
"Nuno Pereira" <n.pereira@.desis.pt> ha scritto nel messaggio
news:17df301c42221$d6cab310$a001280a@.phx
.gbl...
> I had in a customer a ODBC connection to the database sql
> in which I modified the client configurations the
> connection I took off the option to determine door
> dynamicly and placed the 1433 but it gave error and after
> this exactly placing again to determine door dynamicly it
> gives always error and it does not function i remember
> that before this it was to function perfectly. The error
> is:
> Error in Connection:
> SQLState: ' 01000 '
> Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
> Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
> Error in Connection:
> SQLState: ' 08001 ' Error in the SQL Sever: 17 [
> Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
> Server does not exist or the access was refused the
> computer in cause is with all the right definitions of
> net, has access to the server... Please help Me! .
in which I modified the client configurations the
connection I took off the option to determine door
dynamicly and placed the 1433 but it gave error and after
this exactly placing again to determine door dynamicly it
gives always error and it does not function i remember
that before this it was to function perfectly. The error
is:
Error in Connection:
SQLState: ' 01000 '
Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
Error in Connection:
SQLState: ' 08001 ' Error in the SQL Sever: 17 [
Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
Server does not exist or the access was refused the
computer in cause is with all the right definitions of
net, has access to the server... Please help Me! .Hi Nuno,
first of all be sure that you don't have network generic problems, using for
example the dos PING command or TRACERT.
Then I'd reinstall MDAC on client machine (if you've to connect to SQL
Server 7.00 install MDAC 2.5, for SQL 2000 MDAC 2.6SP2), reboot the client
and try again deleting the old DSN and recreating a newest one.
Very important is checking the TCP port is your server listening on (check
the server network utility on your server machine) and the TCP port is your
server transmetting (check the client network utility on your client
machine): they must be identical.
Finally check the authentication mode on your sql server: it must be the
same of the specified into your DSN configuration.
Hope it helps, regards
Riccardo Piccini
Supporto Software
EDP SERVICE SRL
"Nuno Pereira" <n.pereira@.desis.pt> ha scritto nel messaggio
news:17df301c42221$d6cab310$a001280a@.phx
.gbl...
> I had in a customer a ODBC connection to the database sql
> in which I modified the client configurations the
> connection I took off the option to determine door
> dynamicly and placed the 1433 but it gave error and after
> this exactly placing again to determine door dynamicly it
> gives always error and it does not function i remember
> that before this it was to function perfectly. The error
> is:
> Error in Connection:
> SQLState: ' 01000 '
> Error in the SQL Server: 10061 [ Microsoft][ODBC SQL
> Server Driver][TCP/IP Sockets ] ConnectionOpen(Connect()).
> Error in Connection:
> SQLState: ' 08001 ' Error in the SQL Sever: 17 [
> Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]O SQL
> Server does not exist or the access was refused the
> computer in cause is with all the right definitions of
> net, has access to the server... Please help Me! .
Friday, March 9, 2012
Error in Maintenance Plan
This is what I get on one of my DB backups:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:
[Microsoft][ODBC SQL Server Driver][SQL Server]Write
on 'u:\RBMIChevron\RBMIChevron_db_200311131530.BAK'
failed, status = 121. See the SQL Server error log for
more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
DATABASE is terminating abnormally.
AND I have it set to delete after (1) day old and that
fails also. The permissions are fine.
Any help?
Thanks.And as the message indicates, what are the details in the
SQL Server error log?
In terms of the deletes not working, that can happen for
different reasons - generally where the file is in use
(other backups, anti-viruse, etc). It can also happen on Win
95, 98 and ME.
-Sue
On Thu, 20 Nov 2003 06:15:08 -0800, "Rscott"
<rrscott21@.yahoo.com> wrote:
>This is what I get on one of my DB backups:
>[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:
>[Microsoft][ODBC SQL Server Driver][SQL Server]Write
>on 'u:\RBMIChevron\RBMIChevron_db_200311131530.BAK'
>failed, status = 121. See the SQL Server error log for
>more details.
>[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
>DATABASE is terminating abnormally.
>AND I have it set to delete after (1) day old and that
>fails also. The permissions are fine.
>Any help?
>Thanks.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:
[Microsoft][ODBC SQL Server Driver][SQL Server]Write
on 'u:\RBMIChevron\RBMIChevron_db_200311131530.BAK'
failed, status = 121. See the SQL Server error log for
more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
DATABASE is terminating abnormally.
AND I have it set to delete after (1) day old and that
fails also. The permissions are fine.
Any help?
Thanks.And as the message indicates, what are the details in the
SQL Server error log?
In terms of the deletes not working, that can happen for
different reasons - generally where the file is in use
(other backups, anti-viruse, etc). It can also happen on Win
95, 98 and ME.
-Sue
On Thu, 20 Nov 2003 06:15:08 -0800, "Rscott"
<rrscott21@.yahoo.com> wrote:
>This is what I get on one of my DB backups:
>[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:
>[Microsoft][ODBC SQL Server Driver][SQL Server]Write
>on 'u:\RBMIChevron\RBMIChevron_db_200311131530.BAK'
>failed, status = 121. See the SQL Server error log for
>more details.
>[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
>DATABASE is terminating abnormally.
>AND I have it set to delete after (1) day old and that
>fails also. The permissions are fine.
>Any help?
>Thanks.
Sunday, February 26, 2012
Error in DTS
Hi When I try to convert from Prervasive V8 to SQL using an ODBC connection. I receive the error message..
ParseDisplayName failed: The specified module could not be found.
Could anyone advise what this error is? And/Or how it could be resloved. This is happing when I press actualy try to convert. The wizard will go to that point then stop.
Thanks!
DTS or SSIS? This is an SSIS forum. For DTS questions, please visit:http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg
Subscribe to:
Posts (Atom)