Detach database how long

Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information. Support Knowledge base How to detach and attach a SQL database?

Article: Last Published: Ratings: 3 7. If you don't check-mark that option, and users are connected to the database, the database will not be detached. Update Statistics will refresh any out of date statistics before detaching the database. If you leave this option un-checked, statistics objects will remain as they were at the time you detached the database.

Microsoft has an excellent article with more details on MSDN. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Ask Question. Asked 5 years, 10 months ago. However, a backup and restore may take more time than using the attach and detach option.

When a Backup and Restore is done, there is a record created in the MSDB for the operations whereas for the attach and detach option there won't be any record of the event. Taking a database offline leaves the database registration to the SQL Server instance intact, so all you need to do is set it online to make it operational again. Basically, detaching and attaching is used to move database files between SQL Server instances whereas with the Offline option you are unable to move the files.

File activation failure. Related Articles. How to rename a SQL Server database. How to determine SQL Server database transaction log usage. Understanding how SQL Server stores data in data files. Access is denied error when attaching a SQL Server database. Copy a SQL Server database with just the objects and no data. How to stop and start SQL Server services. Popular Articles.

Rolling up multiple rows into a single row and column for SQL Server data. How to tell what SQL Server versions you are running. I have not had it take anything close to this long with other databases before, and it does not seem to be a common issue.

What could be slowing it down? Potentially relevant details:. Anyone have any ideas on why it would take so long, or perhaps what I could do to figure out what is taking so long?

Gail Shaw.