Retrieveing objects

Dears,
I created a table, then dropped it by mistake. Is there any way to retrieve it back using the log file? The lat DB backup was made before creating the table.
Thanks,1. Take a log backup
2. make another database and restore the previous full backup over there as you would not want to make any changes to the original db
3. restore transaction log to a time before you dropped the table
4. copy table onto original database

tell me if you need any other help|||When applying the backup, through the Enterprise Manager, I had the "Point in time restore" option disabled. Have an idea why? Do you think making the backup through the T-SQL better?

Originally posted by Enigma
1. Take a log backup
2. make another database and restore the previous full backup over there as you would not want to make any changes to the original db
3. restore transaction log to a time before you dropped the table
4. copy table onto original database

tell me if you need any other help|||Question : What is your database recovery model

Simple , Full or Bulk Logged

Give me a list of the things you have done till now ...

Retrieve the .rdl file from the reporting services server

Is it possible to retrieve the ".rdl" file published on the Reporting Services
server...
I made a stupid mistake and renamed a report from let say a.rdl to b.rdl
and started to revise the report. Then later on I needed to do some changes
to the published report a.rdl... Though, this file (a.rdl) doesn't exist on
my computer anymore...
Thanks in advance for any tipsHi Andreas:
I'd write an .RSS script file to pull the rdl with the web service.
Look in the books online at the GetReportDefinition method, it even
includes a sample to save the file to disk.
--
Scott
http://www.OdeToCode.com/blogs/scott
On 14 Oct 2004 09:24:17 -0700, akardell@.home.se (Andreas Kardell)
wrote:
>Is it possible to retrieve the ".rdl" file published on the Reporting Services
>server...
>I made a stupid mistake and renamed a report from let say a.rdl to b.rdl
>and started to revise the report. Then later on I needed to do some changes
>to the published report a.rdl... Though, this file (a.rdl) doesn't exist on
>my computer anymore...
>Thanks in advance for any tips|||Wherever the report is deployed, click on the report properties and then
click on the report, the properties tab, the edit link. You will be asked
where you want to save the rdl. Once you have saved the rdl then just add it
back to your project.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andreas Kardell" <akardell@.home.se> wrote in message
news:67424f9d.0410140824.27a8add8@.posting.google.com...
> Is it possible to retrieve the ".rdl" file published on the Reporting
Services
> server...
> I made a stupid mistake and renamed a report from let say a.rdl to b.rdl
> and started to revise the report. Then later on I needed to do some
changes
> to the published report a.rdl... Though, this file (a.rdl) doesn't exist
on
> my computer anymore...
> Thanks in advance for any tips|||Haha! Yep, I've been doing so much WS stuff lately it seems like it is
always the first solution that springs to mind. Thanks for pointing
that one out, Bruce.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Thu, 14 Oct 2004 14:19:19 -0500, "Bruce L-C [MVP]"
<bruce_lcNOSPAM@.hotmail.com> wrote:
>Wherever the report is deployed, click on the report properties and then
>click on the report, the properties tab, the edit link. You will be asked
>where you want to save the rdl. Once you have saved the rdl then just add it
>back to your project.|||Thank you Bruce and Scott!
That saved me a lot of trouble! And really simple solution too... those are
the best ones!
//Andreas
Scott Allen <bitmask@.[nospam].fred.net> wrote in message news:<8ueum0lit3nhpv83bs1jkajg4p1pmfj38s@.4ax.com>...
> Haha! Yep, I've been doing so much WS stuff lately it seems like it is
> always the first solution that springs to mind. Thanks for pointing
> that one out, Bruce.
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
> On Thu, 14 Oct 2004 14:19:19 -0500, "Bruce L-C [MVP]"
> <bruce_lcNOSPAM@.hotmail.com> wrote:
> >Wherever the report is deployed, click on the report properties and then
> >click on the report, the properties tab, the edit link. You will be asked
> >where you want to save the rdl. Once you have saved the rdl then just add it
> >back to your project.

retrieve deleted table

hi there,

by mistake i deleted tables in the DB, i heard once that there is a way to retireve it after it has deleted, from the temp or something like that

so is there a way?

Thanks::so is there a way?

Yes. Apply a backup.

Otherwise: no.