data recovery - pls help

Hi,
If i have some data on a table that's being deleted by an application and i
did not do backup but the recovery mode is "Full Recovery" can i somehow get
back the data ?
i know there's a deleted/ (created or updated) table but that's wtithin a
session isn't it ?
appreciate any advise
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200512/1
hi,
maxzsim via droptable.com wrote:
> Hi,
> If i have some data on a table that's being deleted by an
> application and i did not do backup but the recovery mode is "Full
> Recovery" can i somehow get back the data ?
> i know there's a deleted/ (created or updated) table but that's
> wtithin a session isn't it ?
> appreciate any advise
> tks & rdgs
unfortunately there's no native way... but you can have a look at
http://www.aspfaq.com/show.asp?id=2449 for some tools that enable that kind
of stuff..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
tks for the link that you have provided
rdgs
Andrea Montanari wrote:
>hi,
>[quoted text clipped - 8 lines]
>unfortunately there's no native way... but you can have a look at
>http://www.aspfaq.com/show.asp?id=2449 for some tools that enable that kind
>of stuff..
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200512/1

Data Processing Extension not visible

hello,

I have written a Custom Data Processing Extension for SSRS 2005.

The Report Server is in SharePoint integrated mode, this works perfect except for the extension.

When I want to set a DataSource in SharePoint (WSS 3.0), the extension is not in the ComboBox.

This works well on another server with the same extension.

The DLL file of that extension is copied in the reportserver bin folder.

I have added the references in the rsreportserver.config and rssrvpolicy.config (see below).

Code Snippet

rsreportserver.config

<Data>

<Extension Name="SPSLISTS" Type="ICom.ReportingServices.SharepointListsExtension.Connection,

ICom.ReportingServices.SharepointListsExtension" />

<Data>

Code Snippet

rssrvpolicy.config

This code is located inside the CodeGroup with Name="SharePoint_Server_Strong_Name".

<CodeGroup class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="SPSLISTS_CodeGroup"

Description="Code group for my SPS LISTS data processing extension">

<IMembershipCondition class="UrlMembershipCondition"

version="1"

Url="D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\ICom.ReportingServices.SharepointListsExtension.dll"

/>

</CodeGroup>

I already tried re-installing Reporting Services and the add-in for SharePoint but the problem remains.

Does anyone has an idea of what's wrong here?

Thanks in advance,

Tom

Found the solution, NTFS permissions needed to be set.

|||Hi Tom.

I was wondering if you could elaborate on your solution. I have run into this same problem and am unsure of what NTFS permissions you are talking about. Could you clear that up for me, as I think it would solve my problem as well. Thanks!

V

data missing in the full backup

i have a 2005 db with full recovery mode. daily full backups, diff backups and log backups are done through sqlagent. i wanted to make a copy of it on another instance using the restore method with the latest full backup. after i created the new db, i noticed that a few tables were missing and columns were missing from existing tables also. futhermore, the recrods in these tables were not up-to-date either. i did fresh a full backup and tried again and the problem persisted. i aslo tried to restore on the same sql server instance under a different db name and that reproduced the problem.

the database schema was changed a few weeks ago and it seems that i am only seeing a snapshot of the database before the schema change. dbcc checkdb returns no error. the size of the backup file looks reasonable and i seen an increase in size since the schema change which is expected. there is no active transactions in the db and if i generate a create script, it contains proper t-sql that matches the current schema.

what am i missing there? what could i be doing wrong? i am lost here and any help or advice will be greatly appreciated!

i found the problem. the backup script didn't specify INIT and SKIP so an older set was used by the restore operation.