restore is restoring publisher (sharing DB)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vinay - 19 Feb 2008 16:55 GMT

Hi All,

I have sql 2k std. edition, having one server, removed all the replications
using sp_removedbreplication '<Database name>',
and restarted sql server,

now when i restore the backup i get database with publiser created on it,
and i am not able to delete the database...

Please help...

Signature

Thank you.
Regards,
Vinay Thakur

Reply to this Message

Vinay - 19 Feb 2008 17:27 GMT

Also,

for all new DB restore is DB with publiser...
it is specific to that server, for the same bkp if i restore on another
server it restores perfect.

Appriciate your help.

Signature

Thank you.
Regards,
Vinay Thakur

> Hi All,
>
[quoted text clipped - 6 lines]
>
> Please help...

Reply to this Message

Vinay - 19 Feb 2008 17:53 GMT

Profiler gives me this for restore.

sp_MShelp_replication_status @agent_type = 0, @exclude_anonymous = 0 go
RESTORE DATABASE [test1] FROM DISK = N'E:\DBNMxxx' WITH FILE = 1, NOUNLOAD
, STATS = 10, RECOVERY , REPLACE , MOVE N'Data' TO
N'e:\mssql2k\mssql\data\test1.mdf', MOVE N'xxx_log' TO
N'e:\mssql2k\mssql\data\text1_log.ldf'
go
select name, DATABASEPROPERTY(name, N'IsDetached'), (case when
DATABASEPROPERTY(name, N'IsShutdown') is null then -1 else
DATABASEPROPERTY(name, N'IsShutdown') end), DATABASEPROPERTY(name,
N'IsSuspect'), DATABASEPROPERTY(name, N'IsOffline'),
DATABASEPROPERTY(name, N'IsInLoad'), (case when
DATABASEPROPERTY(name, N'IsInRecovery') is null then -1 else
DATABASEPROPERTY(name, N'IsInRecovery') end), (case when
DATABASEPROPERTY(name, N'IsNotRecovered') is null then -1 else
DATABASEPROPERTY(name, N'IsNotRecovered') end), DATABASEPROPERTY(name,
N'IsEmergencyMode'), DATABASEPROPERTY(name,
N'IsInStandBy'), has_dbaccess(name), status, category, status2 from
master.dbo.sysdatabases
go
exec sp_helpreplicationdboption
go
use [test1]
go
exec sp_helppublication
go
exec sp_helppublication
go
exec sp_helpmergepublication
go
exec sp_helpmergepublication
go
use [master]
go
select name, DATABASEPROPERTY(name, N'IsDetached'), (case when
DATABASEPROPERTY(name, N'IsShutdown') is null then -1 else
DATABASEPROPERTY(name, N'IsShutdown') end), DATABASEPROPERTY(name,
N'IsSuspect'), DATABASEPROPERTY(name, N'IsOffline'),
DATABASEPROPERTY(name, N'IsInLoad'), (case when
DATABASEPROPERTY(name, N'IsInRecovery') is null then -1 else
DATABASEPROPERTY(name, N'IsInRecovery') end), (case when
DATABASEPROPERTY(name, N'IsNotRecovered') is null then -1 else
DATABASEPROPERTY(name, N'IsNotRecovered') end), DATABASEPROPERTY(name,
N'IsEmergencyMode'), DATABASEPROPERTY(name,
N'IsInStandBy'), has_dbaccess(name), status, category, status2 from
master.dbo.sysdatabases
go

use [test1]
go
exec sp_helppullsubscription
go
exec sp_helpmergepullsubscription
go
sp_MShelp_replication_status @agent_type = 0, @exclude_anonymous = 0 go
sp_MShelp_replication_status @agent_type = 0, @exclude_anonymous = 0 go

Signature

Thank you.
Regards,
Vinay Thakur

> Also,
>
[quoted text clipped - 14 lines]
> >
> > Please help...

Reply to this Message

Vinay - 21 Mar 2008 21:15 GMT

Resending...... Please Suggest.

Thanks
Vinay

Signature

Thank you.
Regards,
Vinay Thakur

> Profiler gives me this for restore.
>
[quoted text clipped - 72 lines]
> > >
> > > Please help...

Reply to this Message