Hi,
If a table was deleted, is it possible to roll back the deletion with the
transaction log?
ThanksCheck out www.lumigent.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"BDB" <bdb@.reply.to.group.com> wrote in message
news:%23iSygiyYGHA.508@.TK2MSFTNGP02.phx.gbl...
Hi,
If a table was deleted, is it possible to roll back the deletion with the
transaction log?
Thanks|||Okay this is what I have:
BACKUP LOG mydb
TO DISK= 'mydblog200604180415.bak'
WITH NO_TRUNCATE, INIT
go
use master
go
RESTORE LOG mydb
FROM DISK= 'mydblog200604180415.bak'
WITH STOPAT = 'Apr 18, 2006 3:30 PM'
I get this error:
Msg 3117, Level 16, State 1, Line 2
The log or differential backup cannot be restored because no files are ready
to rollforward.
Msg 3013, Level 16, State 1, Line 2
RESTORE LOG is terminating abnormally.
Can anyone help?|||"BDB" <bdb@.reply.to.group.com> wrote in message
news:%23iSygiyYGHA.508@.TK2MSFTNGP02.phx.gbl...
> Hi,
> If a table was deleted, is it possible to roll back the deletion with the
> transaction log?
You can restore the database and then all logs up to the point in time just
before it was deleted.
If you mean recover the table w/o doing that, http://www.lumigent.com/ may
help.
> Thanks
>|||When you restore log, you first need to restore database, then the log backups, in order. I suggest
you read some in Books Online about backup and restore to get a grip on how this work. Also, you
might want to check out: http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BDB" <bdb@.reply.to.group.com> wrote in message news:%23$zI%23BzYGHA.428@.TK2MSFTNGP02.phx.gbl...
> Okay this is what I have:
> BACKUP LOG mydb
> TO DISK= 'mydblog200604180415.bak'
> WITH NO_TRUNCATE, INIT
> go
> use master
> go
> RESTORE LOG mydb
> FROM DISK= 'mydblog200604180415.bak'
> WITH STOPAT = 'Apr 18, 2006 3:30 PM'
> I get this error:
> Msg 3117, Level 16, State 1, Line 2
> The log or differential backup cannot be restored because no files are ready to rollforward.
> Msg 3013, Level 16, State 1, Line 2
> RESTORE LOG is terminating abnormally.
>
> Can anyone help?
>|||Just keep in mind the below point in the article to minimise impact on
production db.
* Restore into another database and copy the affected data into the
production database.
Thanks
Ajay Rengunthwarsql
Friday, March 30, 2012
Restore deleted table
Is it possible to restore the deleted table? No changes were made to the
database after the table was deleted.
SQL Server 2000.
Thanks.You can restore the database to a new location/name and get at teh table
that way.
"Vik" <viktorum@.==yahoo.com==> wrote in message
news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Is it possible to restore the deleted table? No changes were made to the
> database after the table was deleted.
> SQL Server 2000.
> Thanks.
>|||I just want to make Jay's answer clearer.
First of all, I hope you have a backup of your database. If so, restore your
backup using another name and then export mentioned table to your current
database. (Right click on your restored database and then go to Tasks and
Export...)
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Vik" <viktorum@.==yahoo.com==> wrote in message
news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Is it possible to restore the deleted table? No changes were made to the
> database after the table was deleted.
> SQL Server 2000.
> Thanks.
>|||Try ApexSQL Log.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Vik" <viktorum@.==yahoo.com==> wrote in message
news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Is it possible to restore the deleted table? No changes were made to the
> database after the table was deleted.
> SQL Server 2000.
> Thanks.
>|||Thanks for the replies.
Is there a free tool to work with a transaction log (at least to view it)?
Vik
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:13huna7gk3qcb3a@.corp.supernews.com...
> Try ApexSQL Log.
> --
> Kevin G. Boles
> TheSQLGuru
> Indicium Resources, Inc.
>
> "Vik" <viktorum@.==yahoo.com==> wrote in message
> news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
>> Is it possible to restore the deleted table? No changes were made to the
>> database after the table was deleted.
>> SQL Server 2000.
>> Thanks.
>>
>
database after the table was deleted.
SQL Server 2000.
Thanks.You can restore the database to a new location/name and get at teh table
that way.
"Vik" <viktorum@.==yahoo.com==> wrote in message
news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Is it possible to restore the deleted table? No changes were made to the
> database after the table was deleted.
> SQL Server 2000.
> Thanks.
>|||I just want to make Jay's answer clearer.
First of all, I hope you have a backup of your database. If so, restore your
backup using another name and then export mentioned table to your current
database. (Right click on your restored database and then go to Tasks and
Export...)
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Vik" <viktorum@.==yahoo.com==> wrote in message
news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Is it possible to restore the deleted table? No changes were made to the
> database after the table was deleted.
> SQL Server 2000.
> Thanks.
>|||Try ApexSQL Log.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Vik" <viktorum@.==yahoo.com==> wrote in message
news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Is it possible to restore the deleted table? No changes were made to the
> database after the table was deleted.
> SQL Server 2000.
> Thanks.
>|||Thanks for the replies.
Is there a free tool to work with a transaction log (at least to view it)?
Vik
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:13huna7gk3qcb3a@.corp.supernews.com...
> Try ApexSQL Log.
> --
> Kevin G. Boles
> TheSQLGuru
> Indicium Resources, Inc.
>
> "Vik" <viktorum@.==yahoo.com==> wrote in message
> news:%23I6xAlbFIHA.4880@.TK2MSFTNGP03.phx.gbl...
>> Is it possible to restore the deleted table? No changes were made to the
>> database after the table was deleted.
>> SQL Server 2000.
>> Thanks.
>>
>
restore deleted records
Hi i am currentlly using the SQL sever 2000, i am
wondering is there anyway to restore back the deleted
records which i had deleted at the SQL server table with
the default configuration?
Help it's urgent!!
Thanks...
Regards
sharonSHARON wrote:
> Hi i am currentlly using the SQL sever 2000, i am
> wondering is there anyway to restore back the deleted
> records which i had deleted at the SQL server table with
> the default configuration?
> Help it's urgent!!
> Thanks...
> Regards
> sharon
As long as you are not running simple recovery mode you can use
Lumigent Log explorer to do this http://www.lumigent.com/
Otherwise the only way would be to restore your latest backup.
p.s. if you arent using simple recovery mode and perform regular
transaction log backups you could also restore to a point in time.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============
wondering is there anyway to restore back the deleted
records which i had deleted at the SQL server table with
the default configuration?
Help it's urgent!!
Thanks...
Regards
sharonSHARON wrote:
> Hi i am currentlly using the SQL sever 2000, i am
> wondering is there anyway to restore back the deleted
> records which i had deleted at the SQL server table with
> the default configuration?
> Help it's urgent!!
> Thanks...
> Regards
> sharon
As long as you are not running simple recovery mode you can use
Lumigent Log explorer to do this http://www.lumigent.com/
Otherwise the only way would be to restore your latest backup.
p.s. if you arent using simple recovery mode and perform regular
transaction log backups you could also restore to a point in time.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============
Restore Deleted Instance of SQL 2000
We had a server with SQL 2000 on it. It had two instances. Worked
great.
We decided to upgrade to SQL 2005. We ran the upgrade on the default
instance. Everything was great.
Before we upgraded the second instance, someone went into 'add remove
programs' and removed the second instance of SQL 2000. Can I get it
back?
I created a second instance in SQL 2005 and attached the single
important DB from that second instance of SQL 2000 and the data is all
there, but we are having connection issues. I'm afraid it may be
because we deleted the second instance of SQL 2000 before we got a
chance to upgrade.
Any ideas?
-BDOn Nov 2, 3:16 am, i...@.clowwater.com wrote:
> We had a server with SQL 2000 on it. It had two instances. Worked
> great.
> We decided to upgrade to SQL 2005. We ran the upgrade on the default
> instance. Everything was great.
> Before we upgraded the second instance, someone went into 'add remove
> programs' and removed the second instance of SQL 2000. Can I get it
> back?
> I created a second instance in SQL 2005 and attached the single
> important DB from that second instance of SQL 2000 and the data is all
> there, but we are having connection issues. I'm afraid it may be
> because we deleted the second instance of SQL 2000 before we got a
> chance to upgrade.
> Any ideas?
> -BD
I don't think that this has something to do with the fact that the
second instance was deleted. Can you post more details? What is the
error that you get? Do you get it each time that you try to connect
to the server? Do you also get it if you try to connect to the SQL
Server from the server it self?
Adi
great.
We decided to upgrade to SQL 2005. We ran the upgrade on the default
instance. Everything was great.
Before we upgraded the second instance, someone went into 'add remove
programs' and removed the second instance of SQL 2000. Can I get it
back?
I created a second instance in SQL 2005 and attached the single
important DB from that second instance of SQL 2000 and the data is all
there, but we are having connection issues. I'm afraid it may be
because we deleted the second instance of SQL 2000 before we got a
chance to upgrade.
Any ideas?
-BDOn Nov 2, 3:16 am, i...@.clowwater.com wrote:
> We had a server with SQL 2000 on it. It had two instances. Worked
> great.
> We decided to upgrade to SQL 2005. We ran the upgrade on the default
> instance. Everything was great.
> Before we upgraded the second instance, someone went into 'add remove
> programs' and removed the second instance of SQL 2000. Can I get it
> back?
> I created a second instance in SQL 2005 and attached the single
> important DB from that second instance of SQL 2000 and the data is all
> there, but we are having connection issues. I'm afraid it may be
> because we deleted the second instance of SQL 2000 before we got a
> chance to upgrade.
> Any ideas?
> -BD
I don't think that this has something to do with the fact that the
second instance was deleted. Can you post more details? What is the
error that you get? Do you get it each time that you try to connect
to the server? Do you also get it if you try to connect to the SQL
Server from the server it self?
Adi
Restore Default Trigger Template
Hello,
I am locally running SS2K, but the database is sitting on a SS7 server. I
created a trigger and accidentally clicked the "Save As Template" button.
Is there any way to set the template back to the default?Did you overwrite one of your trigger templates? Which one? You may be able to get it from another machine that has the =client tools installed on your network. Perhaps you could find the =appropriate .tql file on the SQL Server CD.
-- Keith
"Steven K" <sckeels@.lucent.com> wrote in message =news:ucs4#yMbDHA.2668@.TK2MSFTNGP09.phx.gbl...
> Hello,
> > I am locally running SS2K, but the database is sitting on a SS7 =server. I
> created a trigger and accidentally clicked the "Save As Template" =button.
> Is there any way to set the template back to the default?
> >|||Thanks Keith, I overwrote the "new" template. I will get it from another
machine.
"Keith Kratochvil" <keith.kratochvil.back2u@.novusprintmedia.com> wrote in
message news:OUfh9pNbDHA.2588@.TK2MSFTNGP09.phx.gbl...
Did you overwrite one of your trigger templates?
Which one? You may be able to get it from another machine that has the
client tools installed on your network. Perhaps you could find the
appropriate .tql file on the SQL Server CD.
--
Keith
"Steven K" <sckeels@.lucent.com> wrote in message
news:ucs4#yMbDHA.2668@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I am locally running SS2K, but the database is sitting on a SS7 server. I
> created a trigger and accidentally clicked the "Save As Template" button.
> Is there any way to set the template back to the default?
>
I am locally running SS2K, but the database is sitting on a SS7 server. I
created a trigger and accidentally clicked the "Save As Template" button.
Is there any way to set the template back to the default?Did you overwrite one of your trigger templates? Which one? You may be able to get it from another machine that has the =client tools installed on your network. Perhaps you could find the =appropriate .tql file on the SQL Server CD.
-- Keith
"Steven K" <sckeels@.lucent.com> wrote in message =news:ucs4#yMbDHA.2668@.TK2MSFTNGP09.phx.gbl...
> Hello,
> > I am locally running SS2K, but the database is sitting on a SS7 =server. I
> created a trigger and accidentally clicked the "Save As Template" =button.
> Is there any way to set the template back to the default?
> >|||Thanks Keith, I overwrote the "new" template. I will get it from another
machine.
"Keith Kratochvil" <keith.kratochvil.back2u@.novusprintmedia.com> wrote in
message news:OUfh9pNbDHA.2588@.TK2MSFTNGP09.phx.gbl...
Did you overwrite one of your trigger templates?
Which one? You may be able to get it from another machine that has the
client tools installed on your network. Perhaps you could find the
appropriate .tql file on the SQL Server CD.
--
Keith
"Steven K" <sckeels@.lucent.com> wrote in message
news:ucs4#yMbDHA.2668@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I am locally running SS2K, but the database is sitting on a SS7 server. I
> created a trigger and accidentally clicked the "Save As Template" button.
> Is there any way to set the template back to the default?
>
Restore default setting for MSDE
How can I restore the default setting for MSDE to have only WindowsAutentication and not mixed mode? And to have my sa account withoutpassword? Please help me! Thanks, Nibbles
This setting cannot be changed with T-SQL as far as I know. Youcan do it with Enterprise Manager, or with your own custom SQL-DMOprogram, or by changing the registry directly.
Never ever leave the sa account without a pasword! You can change the password using thesp_password system stored procedure.
You will find this article helpful as it addresses both of your needs:How To Verify and Change the MSDE System Administrator Password
sql
Nibbles wrote:
How can I restore the default setting for MSDE to have only WindowsAutentication and not mixed mode?
This setting cannot be changed with T-SQL as far as I know. Youcan do it with Enterprise Manager, or with your own custom SQL-DMOprogram, or by changing the registry directly.
And to have my sa account withoutpassword?
Never ever leave the sa account without a pasword! You can change the password using thesp_password system stored procedure.
You will find this article helpful as it addresses both of your needs:How To Verify and Change the MSDE System Administrator Password
sql
Restore default security settings on MASTER database
I have a utility script that I wrote sometime ago to grant access to all
tables and stored procedures in a database to the PUBLIC user group.
Unfortunately, I used it on another server on which my default database was
not setup and as such it has been run against the MASTER database resulting
in completely screwed security on that database.
It is not a production server and as such I can remove and re-install SQL2k
if required, but before I do; is there any known way to re-instate the
default security settings?
Cheers.U can run rebuildm, this however will rebuild (master, msdb, model) so make
sure U have good backup of msdb and possibly model if you have any specifics
in there.|||Thanks. That was what I was looking for.
Martin.
"Olu Adedeji" <anonymous@.discussions.microsoft.com> wrote in message
news:C55C7D94-1F3F-4C79-955F-8B0565129D92@.microsoft.com...
> U can run rebuildm, this however will rebuild (master, msdb, model) so
make sure U have good backup of msdb and possibly model if you have any
specifics in there.
tables and stored procedures in a database to the PUBLIC user group.
Unfortunately, I used it on another server on which my default database was
not setup and as such it has been run against the MASTER database resulting
in completely screwed security on that database.
It is not a production server and as such I can remove and re-install SQL2k
if required, but before I do; is there any known way to re-instate the
default security settings?
Cheers.U can run rebuildm, this however will rebuild (master, msdb, model) so make
sure U have good backup of msdb and possibly model if you have any specifics
in there.|||Thanks. That was what I was looking for.
Martin.
"Olu Adedeji" <anonymous@.discussions.microsoft.com> wrote in message
news:C55C7D94-1F3F-4C79-955F-8B0565129D92@.microsoft.com...
> U can run rebuildm, this however will rebuild (master, msdb, model) so
make sure U have good backup of msdb and possibly model if you have any
specifics in there.
Subscribe to:
Posts (Atom)