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,
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...
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