Error 15635 on using Configure Distribution Wizard in MS SQL

Asked By barbara mines 0 points N/A Posted on - 02/18/2012

I used the Configure Distribution Wizard in my MS SQL Server 2005 to setup its distributor.

However, I end up with this error box. How to get rid of this and what is the possible fix?

Thanks.

Detach database failed for Server 'Instance Name'. (Microsoft.SqlServer.Smo)

Additional information:

An exception occurred while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.ConnectionInfo)

Cannot execute 'sp_updatestats' because the database is in read-only access mode.

Cannot DETACH a database snapshot. (Microsoft SQL Server, Error: 15635)

• Status: Open
• Question Views: 1595
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By brionas brain 25 points N/A #93122

Error 15635 on using Configure Distribution Wizard in MS SQL

 

The error and cause is very simple because the error came out and tell you already what is the cause because when you tried to detach a database snapshot on your SQL server, it is just saying to you that you cannot attach or detach database snapshots on the SQL

So please avoid doing that because it is not allowed by the system, because this is because of the privacy of the database that is why it is not allowed so please understand that they created SQL to protect its databases. But there are other ways to do your snapshots. Have a great day and enjoy your stay

 

About brionas brain

Questions
3

Answers
191

Best Answers
41

• Vote Up 0 Vote Down

• Posted on - 02/18/2012
• Question Category: MS SQL Server