var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
How to move MSSQL Server data folder
I have a Windows 2003 server, install MSSQL Server 2005.
Initially, I installed on D: \ MSSQL. Folder containing the data in D: \ MSSQL \ MSSQL.1 \ Data.
Now I want to move data folder to E: \ MSSQLDB
How do I transfer the entire database to a new folder?
Change the data directory in MSSQL, stop MSSQ, move the contents, start MSSQL back up. You may need to edit the registry as well for the data and/or transaction log locations.
I want ask, how to "
change" and how to " edit" registry (if need). Where's the value I must change.
Thank you so much
Open SQL Manager, connect to db, Press F1
For user databases, look at the documentation for sp_detach and sp_attach
For system databases, it can be done in the gui manager or, search the ms support site for a kb article on that. It may be a startup parameter, but not likely a registry edit.
You might also want to look at the MSSQL BOL.
By angelsp in forum Dedicated Server
Last Post: 07-29-2008, 12:31 AM
By surfmanjoe in forum Dedicated Server
Last Post: 06-19-2007, 08:39 AM
By SupermanInNY in forum Hosting Security and Technology
Last Post: 06-13-2006, 05:25 PM
By constantine in forum Web Hosting
Last Post: 04-07-2005, 02:51 AM
By giza in forum Dedicated Server
Last Post: 06-04-2002, 12:14 PM