Error when create archive for DB Using Database Publishing Wizard!
Please help me following error when create archive DB using Database Publishing Wizard!
Error Message: Database Publishing Progress
- Gathering list of objects to script (Success)
- Scripting objects (Success)
- Writing table dbo.b_Users (Error) Messages Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. (System.Data) Imag
Hi! It's hard to understand what's going on from your post. You may try to use SQL profiler to see what commands are active and what is the cause of timeout. I suggest simply not to use publishing wizard at all. You can just copy site from one location to another and restore your db on new server.
Check if the database server is experiencing high load or network congestion. If so, try reducing the load on the server or improving the network connection to resolve the issue.
Increase the connection timeout setting in the Database Publishing Wizard. To do this, go to the Advanced Settings tab and increase the value for the "Connection Timeout" option.
Check if there are any connection pooling issues on the database server. Connection pooling allows the database server to reuse existing connections, which can improve performance and reduce the need to establish new connections. If the connection pool is exhausted, this can cause timeout errors. You can try increasing the size of the connection pool or resetting it to resolve this issue.
Check if there are any issues with the database itself, such as corruption or other issues that may be causing the timeout error. You can try running the database's built-in consistency checks or restoring the database from a backup to resolve these issues.
These are some of the steps you could follow and they might help you resolve your problems for further solutions, you can hire someone to do my online class for me.