How to remove a push subscription?

I have a publication within a transactional replication with a push
subscription. I had deleted the subscription on the Publisher through the EM.
And Publisher EM showed the subscription is removed. But when I checked the
Subscriber EM, the subscription is still there under the
Replication\Subscriptions, and it seems there is no way to remove it on
Subscriber EM. Can someone please help me on this? How do I remove it on the
subscriber?
Thanks,
Hi,
to dtop a pull subscription you can use:
sp_droppullsubscription system stored procedures.
hope it works fine with you.
SaeedA
"FYK" wrote:

> I have a publication within a transactional replication with a push
> subscription. I had deleted the subscription on the Publisher through the EM.
> And Publisher EM showed the subscription is removed. But when I checked the
> Subscriber EM, the subscription is still there under the
> Replication\Subscriptions, and it seems there is no way to remove it on
> Subscriber EM. Can someone please help me on this? How do I remove it on the
> subscriber?
> Thanks,
|||Hi,
You can use :
sp_dropsubscription, you can see BOL for more details
SaeedA
"FYK" wrote:

> I have a publication within a transactional replication with a push
> subscription. I had deleted the subscription on the Publisher through the EM.
> And Publisher EM showed the subscription is removed. But when I checked the
> Subscriber EM, the subscription is still there under the
> Replication\Subscriptions, and it seems there is no way to remove it on
> Subscriber EM. Can someone please help me on this? How do I remove it on the
> subscriber?
> Thanks,

how to recover deleted reports

I accidentally deleted few reports from reporting service management site.
how can i recover them? Thank you.Unless you have a backup you can't (of reporting services database). You
would need to redeploy these reports.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"showjohnathan" <showjohnathan@.discussions.microsoft.com> wrote in message
news:07A380C6-5AF2-430E-A04D-F4A13B5249C5@.microsoft.com...
>I accidentally deleted few reports from reporting service management site.
> how can i recover them? Thank you.|||thanks
"Bruce L-C [MVP]" wrote:
> Unless you have a backup you can't (of reporting services database). You
> would need to redeploy these reports.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "showjohnathan" <showjohnathan@.discussions.microsoft.com> wrote in message
> news:07A380C6-5AF2-430E-A04D-F4A13B5249C5@.microsoft.com...
> >I accidentally deleted few reports from reporting service management site.
> > how can i recover them? Thank you.
>
>

How to recover deleted data from master database

Hi all,
I made a horrible thing this week. I have an script that delete all data from all user tables, and I run it in the master database.
After this I couldn't access the metadata from the tables of my databases using a JDBC connection.
My script runs over all sysobject that are different from dtproperties.
I don't have a back up of master table. I have tried to copy the data from another master database (from another machine) but I did not work. I tried to copy from a xls, but it did'nt work too. I try do recover the master database (as it is explained in the online books) but it did not work either.

Someone know how can I recover this data?Here is the script:

declare @.table_name sysname
declare @.alter_table_statement varchar(256)
declare @.delete_statement varchar(256)

declare table_name_cursor cursor local fast_forward for
select
name
from
sysobjects
where
xtype = 'U'
and
name <> 'dtproperties'

open table_name_cursor
fetch next from table_name_cursor into @.table_name
select @.alter_table_statement = 'alter table ' + ltrim(rtrim(@.table_name)) + ' nocheck constraint all'
exec(@.alter_table_statement)
while @.@.Fetch_Status = 0
begin
fetch next from table_name_cursor into @.table_name
select @.alter_table_statement = 'alter table ' + ltrim(rtrim(@.table_name)) + ' nocheck constraint all'
exec(@.alter_table_statement)
end
close table_name_cursor

open table_name_cursor
fetch next from table_name_cursor into @.table_name
select @.delete_statement = 'delete from ' + ltrim(rtrim(@.table_name))
exec(@.delete_statement)
while @.@.Fetch_Status = 0
begin
fetch next from table_name_cursor into @.table_name
select @.delete_statement = 'delete from ' + ltrim(rtrim(@.table_name))
exec(@.delete_statement)
end
close table_name_cursor

-- ligando os vnculos...
open table_name_cursor
fetch next from table_name_cursor into @.table_name
select @.alter_table_statement = 'alter table ' + ltrim(rtrim(@.table_name)) + ' check constraint all'
exec(@.alter_table_statement)
while @.@.Fetch_Status = 0
begin
fetch next from table_name_cursor into @.table_name
select @.alter_table_statement = 'alter table ' + ltrim(rtrim(@.table_name)) + ' check constraint all'
exec(@.alter_table_statement)
end
close table_name_cursor

deallocate table_name_cursor

And here is the names of the tables of master database that this script had deleted all the containing data:
spt_monitor
spt_values
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
spt_provider_types
spt_datatype_info_ext
MSreplication_options
spt_datatype_info
spt_server_info
spt_server_info

How to recover a deleted table

Hi
We accidentally deleted a table of a DB and we have the log. Is there any
way to recover ? (without using log explorer from lumigent)
Thanks in advance
Hi,
You can use POINT_IN_TIME restore if your Recovery mode for that database is
FULL plus you should have full database backup , transaction log backups.
Stes:-
1. Take a backup transaction log in current database
2. Create a new database
3. Restore with full backup file with NORECOVERY (Use below command)
RESTORE database new_dbname from disk='file' with NORECOVERY, MOve
'logical_mdf' to 'physical_mdf',
move 'logical_ldf' to 'physical_ldf'
4. Restore the subsequent transaction log backups in NORECOVERY mode.
5. Restore the transaction log backup taken in step-1 with RECOVERY and
STOPAT option
RESTORE log new_dbname from disk='tran_backup_file' with RECOVERY,
STOPAT= ''Aug 05, 2004 03:44 AM'
Date and Time should be given based on your requirement for STOPAT option.
Thanks
Hari
MCDBA
"Mark Bushnell" <markbn@.bushnell.com> wrote in message
news:ulc4sAqeEHA.2028@.tk2msftngp13.phx.gbl...
> Hi
> We accidentally deleted a table of a DB and we have the log. Is there any
> way to recover ? (without using log explorer from lumigent)
> Thanks in advance
>

How to recover a deleted table

Hi
We accidentally deleted a table of a DB and we have the log. Is there any
way to recover ? (without using log explorer from lumigent)
Thanks in advance
HI
If you have full backup:
First backup log.
Restore db on another server with no recovery, and restore log with stopat before time of table deleted. If you don't know the correct time, you can repeat this with approach to expected time.
Copy table and data to original database.
Andras Jakus MCDBA
"Mark Bushnell" wrote:

> Hi
> We accidentally deleted a table of a DB and we have the log. Is there any
> way to recover ? (without using log explorer from lumigent)
> Thanks in advance
>
>

How to recover a deleted table

Hi
We accidentally deleted a table of a DB and we have the log. Is there any
way to recover ? (without using log explorer from lumigent)
Thanks in advanceHI
If you have full backup:
First backup log.
Restore db on another server with no recovery, and restore log with stopat b
efore time of table deleted. If you don't know the correct time, you can rep
eat this with approach to expected time.
Copy table and data to original database.
Andras Jakus MCDBA
"Mark Bushnell" wrote:

> Hi
> We accidentally deleted a table of a DB and we have the log. Is there any
> way to recover ? (without using log explorer from lumigent)
> Thanks in advance
>
>

How to recover a deleted table

Hi
We accidentally deleted a table of a DB and we have the log. Is there any
way to recover ? (without using log explorer from lumigent)
Thanks in advanceHI
If you have full backup:
First backup log.
Restore db on another server with no recovery, and restore log with stopat before time of table deleted. If you don't know the correct time, you can repeat this with approach to expected time.
Copy table and data to original database.
Andras Jakus MCDBA
"Mark Bushnell" wrote:
> Hi
> We accidentally deleted a table of a DB and we have the log. Is there any
> way to recover ? (without using log explorer from lumigent)
> Thanks in advance
>
>

HOW TO RECOVER A DELETED DB

I NEED SOME SERIOUS HELP
I deleted a production database accidentally, because the person who created
named it test, so I figure that it was ok to deleted.
Well we don't have any type of backups for this Database.
I need to know if there a tool out there can retrieve these files from a
RAID 5.
Where do the files go when you right click in enterprise manager and delete
the DB?Where did the file go -it went 'poof' into the ether...
IF there has been no other writing activity to the RAID, you may find some
low level file recovery tools to help. Check with the RAID provider, and try
SysInternals.
There is nothing that SQL Server can do to help you recover the file.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Peter" <Vik> wrote in message
news:%233JoBiuxGHA.1300@.TK2MSFTNGP05.phx.gbl...
>I NEED SOME SERIOUS HELP
> I deleted a production database accidentally, because the person who
> created named it test, so I figure that it was ok to deleted.
> Well we don't have any type of backups for this Database.
> I need to know if there a tool out there can retrieve these files from a
> RAID 5.
>
> Where do the files go when you right click in enterprise manager and
> delete the DB?
>

HOW TO RECOVER A DELETED DB

I NEED SOME SERIOUS HELP
I deleted a production database accidentally, because the person who created
named it test, so I figure that it was ok to deleted.
Well we don't have any type of backups for this Database.
I need to know if there a tool out there can retrieve these files from a
RAID 5.
Where do the files go when you right click in enterprise manager and delete
the DB?Where did the file go -it went 'poof' into the ether...
IF there has been no other writing activity to the RAID, you may find some
low level file recovery tools to help. Check with the RAID provider, and try
SysInternals.
There is nothing that SQL Server can do to help you recover the file.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Peter" <Vik> wrote in message
news:%233JoBiuxGHA.1300@.TK2MSFTNGP05.phx.gbl...
>I NEED SOME SERIOUS HELP
> I deleted a production database accidentally, because the person who
> created named it test, so I figure that it was ok to deleted.
> Well we don't have any type of backups for this Database.
> I need to know if there a tool out there can retrieve these files from a
> RAID 5.
>
> Where do the files go when you right click in enterprise manager and
> delete the DB?
>

How to read log Files

Some records got deleted from our DB. We don't have any triggers to log this delete transaction. Is there anyway to find out from log files or someother places to find out about this deletion. Is this information stored in transaction log. We do complete backup every night. So I think the transaction log will be truncated after the complete backup right?
Please advise on this.

thanksIf recovery mode is Full then Lumigent Log Explorer (http://www.lumigent.com)(FULL VERSION) can be installed and the specific transaction can be identified. If recovery mode is Simple, Log Explorer can still be used, but chances of recovering the transaction are much-much slimmer.