|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sql2000 wrong delete can restore??????????anyone help!!
if i deleted several rows from sql2000, and i had no backup,no trans log, can i restore what i deleted? if yes, tell me more... thanks You can try any of the log reader products (I've listed some on my links page:
http://www.karaszi.com/SQLServer/links.asp). But since you don't have any backups at all, there is a high risk that the log records have already been removed from the transaction log file (ldf). -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "lizj" <l***@zhifang.com.cn> wrote in message news:umJYCyCIHHA.1784@TK2MSFTNGP06.phx.gbl... > anyone help!! > > if i deleted several rows from sql2000, and i had no backup,no trans log, > can i restore what i deleted? if yes, tell me more... > > thanks >
http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html
Show quote "lizj" <l***@zhifang.com.cn> wrote in message
news:umJYCyCIHHA.1784@TK2MSFTNGP06.phx.gbl... > anyone help!! > > if i deleted several rows from sql2000, and i had no backup,no trans log, > can i restore what i deleted? if yes, tell me more... > > thanks > thank you all
-- Show quote£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½ ******************************************************* £½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½ "lizj" <l***@zhifang.com.cn> дÈëÏûÏ¢ news:umJYCyCIHHA.1784@TK2MSFTNGP06.phx.gbl... > anyone help!! > > if i deleted several rows from sql2000, and i had no backup,no trans log, > can i restore what i deleted? if yes, tell me more... > > thanks >  |
|||||||||||||||||||||||
Other interesting topics