Thursday, August 22, 2019

Detach and Attach SQL Server Database

Detach and Attach SQL Server Database

how to Detach and Attach SQL Server Database using SQL Server Management studio?

First,


According to the above, picture Detach your Selected database.
Next,

According to the above, picture Select "Update Stats" And Select "OK".
Next,
Move Database File Old Location to New location,
Ex: C:\databaseusergroup.mdf to D:\databaseusergroup.mdf
And Next Select "Attach" like Following Picture,

Next,
Attach Database like Following Pictures,
(If You Have multiple data file then you need to select only main MDF file)

Cheers...
and Most welcome your comments and ideas...
Posted by at

7 comments:

  1. Jos KenyThursday, January 9, 2020 at 1:28:00 PM GMT+5:30

    The l-shaped computer desk gives you maximum desktop space while still fitting into almost any size office. The desktop is made out of thick MDF board, keeping it lightweight but still looking good

    ReplyDelete
  2. Big BangTuesday, October 27, 2020 at 12:53:00 PM GMT+5:30

    I just couldn't leave your website before telling you that I truly enjoyed the top quality info you present to your visitors? Will be back again frequently to check up on new posts. שרת וירטואלי

    ReplyDelete
  3. Jack JohnnySaturday, November 7, 2020 at 3:04:00 PM GMT+5:30

    Very useful post. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up. gépszállítás Europa-Road Kft

    ReplyDelete
  4. king levisterThursday, December 10, 2020 at 8:32:00 PM GMT+5:30

    hello!! Very interesting discussion glad that I came across such informative post. Keep up the good work friend. Glad to be part of your net community. sviluppo sito ecommerce

    ReplyDelete
  5. aliWednesday, December 23, 2020 at 11:07:00 AM GMT+5:30

    Very useful post. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up.
    https://serveria.com

    ReplyDelete
  6. henrrySaturday, April 3, 2021 at 3:09:00 PM GMT+5:30

    All information passing via proxy servers can be analyzed before they reach any terminal. This feature is used to block spyware and other viruses from affecting a user's computer too.how to choose the right vpn

    ReplyDelete
  7. Louis TomThursday, June 3, 2021 at 1:59:00 PM GMT+5:30

    For the following quite a long while, Georgia Tech's football program would perform inadequately. Thus, they chose to enlist another mentor from another opponent school, Clemson. In 1904, John Heisman was paid $2,250 and 30% of participation charges to be Georgia Tech's football and baseball trainer. netflix vpn free

    ReplyDelete

Subscribe to: Post Comments (Atom)