Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: sp_attach_db

Attach all user databases

I was doing an upgrade of one of our development servers to SQL Server 2008. To minimize the downtime I decided to attach all the user databases using script. Basically, I am attaching the db from the same location there were present earlier to being detached. Consider the following example, If I have a database… Continue reading Attach all user databases

Published May 3, 2010
Categorized as Scripts Tagged attach, scripts, sp_attach_db

Recent Posts

  • CSSUG February 2020 Meet
  • CSSUG January 2020 Meet
  • CSSUG November 2019 Meet
  • CSSUG October 2019 Meet
  • Dropping a Subscriber from AG Publisher
SQL-Articles
Proudly powered by WordPress.