Move SQL Database
in [Server Configuration]
|
Prev: Error 22042: xp_SetSQLSecurity() returned error - 2147024690, 'The handle is invalid.'
Next: COPY_ONLY Restore Problems
From: frm3389 on 6 Sep 2007 16:46 i am not a sql programmer, but I need to move two "user databases" in a sql 2005 express installation from one drive to another. This article explains what I need but it says I need to run some commands, but not where to type the command or run them. http://support.microsoft.com/kb/224071 Anyway can I just detach, move the data and log file and then reatach it using the SQL Server Management Studio Express? Thanks
From: John Bell on 7 Sep 2007 04:14 Hi The commands should be run from a SQLCMD prompt at the command line. If SSMSE is the same as SSMS then you can right click the database node choose all tasks and then attach from the menus. John "frm3389" wrote: > i am not a sql programmer, but I need to move two "user databases" in a sql > 2005 express installation from one drive to another. > This article explains what I need but it says I need to run some commands, > but not where to type the command or run them. > > http://support.microsoft.com/kb/224071 > > Anyway can I just detach, move the data and log file and then reatach it > using the SQL Server Management Studio Express? > > Thanks
From: Ekrem Önsoy on 7 Sep 2007 04:13 Absolutely! Go that way if you don't wanna bother yourself with those code pieces. Warning: It those databases are in a production environment, to prevent any data loss, you may want to change your databases "Restrict Access" property to SINGLE_USER (from database options) and then do not forget to set it back to MULTI_USER to avoid any possible chaos :) -- Ekrem Önsoy "frm3389" <frm3389(a)discussions.microsoft.com> wrote in message news:14312EB2-50D5-447B-895E-DD861F80AD24(a)microsoft.com... >i am not a sql programmer, but I need to move two "user databases" in a sql > 2005 express installation from one drive to another. > This article explains what I need but it says I need to run some commands, > but not where to type the command or run them. > > http://support.microsoft.com/kb/224071 > > Anyway can I just detach, move the data and log file and then reatach it > using the SQL Server Management Studio Express? > > Thanks
From: frm3389 on 7 Sep 2007 10:44
Thanks for the added advice. That is what I needed. |