Solved

To delete system views created by replication.

Posted on 2010-08-18
2
478 Views
Last Modified: 2012-08-13

I have deleted all the replications, publications,subscriptions from my server.

There are many synobj views which were not deleted by system.

the view names are like
syncobj_0x3533464132323033
syncobj_0x3138463935344234
syncobj_0x3130454430424245
syncobj_0x3830354145374444
syncobj_0x4435313930423141
syncobj_0x3136433335433042
syncobj_0x3739343743384145
syncobj_0x3835444346433032
syncobj_0x3333363034413945
syncobj_0x4342423330314446

Is it safe to delete these views manually?
What is the safe method of delete?
0
Comment
Question by:Mehram
2 Comments
 
LVL 3

Accepted Solution

by:
PrakashRaoBS earned 500 total points
ID: 33462937
These objects are used when generating the snapshots. If your table is
large, or if your article on the publisher is different from the article on
the subscriber (horizontal or vertical partitioning - in other words a
different number of rows or columns), SQL Server chooses to replicate from
views (called sync objects) instead of the underlying base tables.

If your replication is not active then you can drop these views. Otherwise if you drop the views, it will get affect one the replication snapshot is getting synced.

These system views are used during the snapshot process. Instead of deleting these views, You could assign them to the db_reader role.
0
 

Author Closing Comment

by:Mehram
ID: 33498182
Thanks
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question