Ram,

What type of replication you have configured?

Why u need to copy articles from Subscriber to Publisher, already Publisher will push articles to subscriber?

How is your replication configured ?

- Win.

Anyone faced the issue. Any thoughts and suggestions, please post.

Anyone faced thus type of issue...

Will replication manual drop also drops Constraints on Subscriber. Even i didnt faced earlier in past 2 yrs... This case is frustrating...

Anyone pls post a...

I tested the same steps once again with the Port number : 587.

It worked like a charm. recieved mails from server.

Try with port : 587

Resolved the Issues...

Now am able to Backup to network and also able to restore from network path + overwrite..

Thanks.

Thanks Pradeep Singh,

I tried working with network folders and backing up the database to NETWORK path. It was succesfully backed up.

Here now am facing to restore the same backup file...

Hi All,

I could get the Roles + Permissions + Object level permissions.

My Query : I also need a SCHEMA scripts and the same schema scripts are to be...

🙂

Thanks Bhuvanesh,

This inserts the data from one table to another table (instance).

But this is not a part of archiving. I knew we can insert the data into other table. The...

Hi All,

Older post.... but the new requirement......

I also executed the same script and tried as Kelly & Rowshambo suggested, but it failed with the below error...

___________________________________________________________________________

Msg 102, Level 15, State...

Thanks Suresh for post.

I tried the same... But didnt clicked on my env.

There is a simple thing which hanged. Let me post here so that every one can check and...

Yes,

DB backup is restored and then replication is configured.

Could you please elaborate how to check the SIDs and how it can effect the logins.?

Good point, thanks. tried this as well...

But i have to use in script, thats the criteria..

But how to archive from one instance to another instance.

Any script code for that to archive the data from one instance to another...

I think you can get some info from this table 1: MSsubscription_properties

&

2: MSsnapshotdeliveryprogress

progress_timestamp

datetime

The datetime value that indicates when a snapshot file was successfully delivered.

Good Luck...

Thats what the issue is with...

Is there any way to map the users from DB level to Logins in Server level...