Hi all
I hv wrongly updated some stored proecedures in my database. I dont have
backup and i didnt put begin trans. Is it possible to rollback or anyother
option (restore the database in the stage before one hour like that).
Regards
B. Sundar
You might get some help from a tool which reads the tran log from lumigent
( log explorer, www.lumigent.com)
But otherwise no other way... Of course, you should put all of your code
( including SPs, etc ) in change control, but that doesn't help you now...
sorry
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sundar" <Sundar@.discussions.microsoft.com> wrote in message
news:DEB3A28F-2EF9-4547-B342-B836A26CFBF0@.microsoft.com...
> Hi all
> I hv wrongly updated some stored proecedures in my database. I dont have
> backup and i didnt put begin trans. Is it possible to rollback or anyother
> option (restore the database in the stage before one hour like that).
> Regards
> B. Sundar
sql
Showing posts with label alli. Show all posts
Showing posts with label alli. Show all posts
Friday, March 23, 2012
Restore the Stored Procedure - No backup
Hi all
I hv wrongly updated some stored proecedures in my database. I dont have
backup and i didnt put begin trans. Is it possible to rollback or anyother
option (restore the database in the stage before one hour like that).
Regards
B. SundarYou might get some help from a tool which reads the tran log from lumigent
( log explorer, www.lumigent.com)
But otherwise no other way... Of course, you should put all of your code
( including SPs, etc ) in change control, but that doesn't help you now...
sorry
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sundar" <Sundar@.discussions.microsoft.com> wrote in message
news:DEB3A28F-2EF9-4547-B342-B836A26CFBF0@.microsoft.com...
> Hi all
> I hv wrongly updated some stored proecedures in my database. I dont have
> backup and i didnt put begin trans. Is it possible to rollback or anyother
> option (restore the database in the stage before one hour like that).
> Regards
> B. Sundar
I hv wrongly updated some stored proecedures in my database. I dont have
backup and i didnt put begin trans. Is it possible to rollback or anyother
option (restore the database in the stage before one hour like that).
Regards
B. SundarYou might get some help from a tool which reads the tran log from lumigent
( log explorer, www.lumigent.com)
But otherwise no other way... Of course, you should put all of your code
( including SPs, etc ) in change control, but that doesn't help you now...
sorry
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sundar" <Sundar@.discussions.microsoft.com> wrote in message
news:DEB3A28F-2EF9-4547-B342-B836A26CFBF0@.microsoft.com...
> Hi all
> I hv wrongly updated some stored proecedures in my database. I dont have
> backup and i didnt put begin trans. Is it possible to rollback or anyother
> option (restore the database in the stage before one hour like that).
> Regards
> B. Sundar
Monday, March 12, 2012
restore problem
HELLO ALL
I have a problem about DB restor:
I have a backup file of a DB about 600MB,when i try to restore on
another server running SQL SERVER 2000 with same sp3,it show me the error :
Microsoft SQL-DMO(ODBC SQLState:42000)
An internal consistency occurred.Contact Technical Support for
assistance.RESTORE DATABASE is terminating abnormally.
The original database has been erased,all i have is the backup file.
Anyone tell me how this happen and how to resolve it?
Thanks a lot.
Danny
Can you show us your RESTORE command?
"Danny Lu" <xlu2@.hotmail.com> wrote in message
news:elbc%23YlGFHA.2132@.TK2MSFTNGP14.phx.gbl...
> HELLO ALL
> I have a problem about DB restor:
> I have a backup file of a DB about 600MB,when i try to restore on
> another server running SQL SERVER 2000 with same sp3,it show me the error
:
> Microsoft SQL-DMO(ODBC SQLState:42000)
> An internal consistency occurred.Contact Technical Support for
> assistance.RESTORE DATABASE is terminating abnormally.
> The original database has been erased,all i have is the backup file.
> Anyone tell me how this happen and how to resolve it?
> Thanks a lot.
>
|||Sounds to me like you should do what the error say. There is a problem in the backup and you need MS
to possibly help you. Or go to the prior database backup (and possibly all subsequent log backups).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Danny Lu" <xlu2@.hotmail.com> wrote in message news:elbc%23YlGFHA.2132@.TK2MSFTNGP14.phx.gbl...
> HELLO ALL
> I have a problem about DB restor:
> I have a backup file of a DB about 600MB,when i try to restore on another server running SQL
> SERVER 2000 with same sp3,it show me the error :
> Microsoft SQL-DMO(ODBC SQLState:42000)
> An internal consistency occurred.Contact Technical Support for assistance.RESTORE DATABASE is
> terminating abnormally.
> The original database has been erased,all i have is the backup file.
> Anyone tell me how this happen and how to resolve it?
> Thanks a lot.
>
I have a problem about DB restor:
I have a backup file of a DB about 600MB,when i try to restore on
another server running SQL SERVER 2000 with same sp3,it show me the error :
Microsoft SQL-DMO(ODBC SQLState:42000)
An internal consistency occurred.Contact Technical Support for
assistance.RESTORE DATABASE is terminating abnormally.
The original database has been erased,all i have is the backup file.
Anyone tell me how this happen and how to resolve it?
Thanks a lot.
Danny
Can you show us your RESTORE command?
"Danny Lu" <xlu2@.hotmail.com> wrote in message
news:elbc%23YlGFHA.2132@.TK2MSFTNGP14.phx.gbl...
> HELLO ALL
> I have a problem about DB restor:
> I have a backup file of a DB about 600MB,when i try to restore on
> another server running SQL SERVER 2000 with same sp3,it show me the error
:
> Microsoft SQL-DMO(ODBC SQLState:42000)
> An internal consistency occurred.Contact Technical Support for
> assistance.RESTORE DATABASE is terminating abnormally.
> The original database has been erased,all i have is the backup file.
> Anyone tell me how this happen and how to resolve it?
> Thanks a lot.
>
|||Sounds to me like you should do what the error say. There is a problem in the backup and you need MS
to possibly help you. Or go to the prior database backup (and possibly all subsequent log backups).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Danny Lu" <xlu2@.hotmail.com> wrote in message news:elbc%23YlGFHA.2132@.TK2MSFTNGP14.phx.gbl...
> HELLO ALL
> I have a problem about DB restor:
> I have a backup file of a DB about 600MB,when i try to restore on another server running SQL
> SERVER 2000 with same sp3,it show me the error :
> Microsoft SQL-DMO(ODBC SQLState:42000)
> An internal consistency occurred.Contact Technical Support for assistance.RESTORE DATABASE is
> terminating abnormally.
> The original database has been erased,all i have is the backup file.
> Anyone tell me how this happen and how to resolve it?
> Thanks a lot.
>
Friday, March 9, 2012
restore problem
HELLO ALL
I have a problem about DB restor:
I have a backup file of a DB about 600MB,when i try to restore on
another server running SQL SERVER 2000 with same sp3,it show me the error :
Microsoft SQL-DMO(ODBC SQLState:42000)
An internal consistency occurred.Contact Technical Support for
assistance.RESTORE DATABASE is terminating abnormally.
The original database has been erased,all i have is the backup file.
Anyone tell me how this happen and how to resolve it?
Thanks a lot.Danny
Can you show us your RESTORE command?
"Danny Lu" <xlu2@.hotmail.com> wrote in message
news:elbc%23YlGFHA.2132@.TK2MSFTNGP14.phx.gbl...
> HELLO ALL
> I have a problem about DB restor:
> I have a backup file of a DB about 600MB,when i try to restore on
> another server running SQL SERVER 2000 with same sp3,it show me the error
:
> Microsoft SQL-DMO(ODBC SQLState:42000)
> An internal consistency occurred.Contact Technical Support for
> assistance.RESTORE DATABASE is terminating abnormally.
> The original database has been erased,all i have is the backup file.
> Anyone tell me how this happen and how to resolve it?
> Thanks a lot.
>|||Sounds to me like you should do what the error say. There is a problem in th
e backup and you need MS
to possibly help you. Or go to the prior database backup (and possibly all s
ubsequent log backups).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Danny Lu" <xlu2@.hotmail.com> wrote in message news:elbc%23YlGFHA.2132@.TK2MSFTNGP14.phx.gbl.
.
> HELLO ALL
> I have a problem about DB restor:
> I have a backup file of a DB about 600MB,when i try to restore on anoth
er server running SQL
> SERVER 2000 with same sp3,it show me the error :
> Microsoft SQL-DMO(ODBC SQLState:42000)
> An internal consistency occurred.Contact Technical Support for assistance.
RESTORE DATABASE is
> terminating abnormally.
> The original database has been erased,all i have is the backup file.
> Anyone tell me how this happen and how to resolve it?
> Thanks a lot.
>
I have a problem about DB restor:
I have a backup file of a DB about 600MB,when i try to restore on
another server running SQL SERVER 2000 with same sp3,it show me the error :
Microsoft SQL-DMO(ODBC SQLState:42000)
An internal consistency occurred.Contact Technical Support for
assistance.RESTORE DATABASE is terminating abnormally.
The original database has been erased,all i have is the backup file.
Anyone tell me how this happen and how to resolve it?
Thanks a lot.Danny
Can you show us your RESTORE command?
"Danny Lu" <xlu2@.hotmail.com> wrote in message
news:elbc%23YlGFHA.2132@.TK2MSFTNGP14.phx.gbl...
> HELLO ALL
> I have a problem about DB restor:
> I have a backup file of a DB about 600MB,when i try to restore on
> another server running SQL SERVER 2000 with same sp3,it show me the error
:
> Microsoft SQL-DMO(ODBC SQLState:42000)
> An internal consistency occurred.Contact Technical Support for
> assistance.RESTORE DATABASE is terminating abnormally.
> The original database has been erased,all i have is the backup file.
> Anyone tell me how this happen and how to resolve it?
> Thanks a lot.
>|||Sounds to me like you should do what the error say. There is a problem in th
e backup and you need MS
to possibly help you. Or go to the prior database backup (and possibly all s
ubsequent log backups).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Danny Lu" <xlu2@.hotmail.com> wrote in message news:elbc%23YlGFHA.2132@.TK2MSFTNGP14.phx.gbl.
.
> HELLO ALL
> I have a problem about DB restor:
> I have a backup file of a DB about 600MB,when i try to restore on anoth
er server running SQL
> SERVER 2000 with same sp3,it show me the error :
> Microsoft SQL-DMO(ODBC SQLState:42000)
> An internal consistency occurred.Contact Technical Support for assistance.
RESTORE DATABASE is
> terminating abnormally.
> The original database has been erased,all i have is the backup file.
> Anyone tell me how this happen and how to resolve it?
> Thanks a lot.
>
Subscribe to:
Posts (Atom)