miércoles, 11 de abril de 2012 20:00
MY ISSUE: On server-1, windows server 2008 Standard SP1 is installed, alond with SQL Server 2008 R2 Workgroup. There is only one hard drive in the server. There are two partitions [(C: - 40GB), (D: - 35GB)]. D: is for shared files. Now here is where my problem lies:
The C: is getting full and I cant update the server because there is not enough space for the updates. So I am wanting to delete D: and dedicate that space to C:, HOWEVER, there is a folder on D: that I am worried about. Below I will list the folder in question and all the subfolders below that, so in the root of the d:, it goes like this:
Microsoft SQL Server
MSRS10_50.MSSQLSERVER & MSSQL10_50.MSSQLSERVER
Now this foler :MSRS10_50.MSSQLSERVER has reporting services foler in it.
And this folder: MSSQL10_50.MSSQLSERVER has these folders in it:
I need to move everything that is on the D: onto a new 1TB external hard drive. Is this feasable?????? Thanks in advance.
Todas las respuestas
miércoles, 11 de abril de 2012 21:07Yes you can but make sure you stop all the sql services on that server. Then move from the D drive to the External drive, assign the current D drive another letter and finally assign D letter to the external drive. Make sure you have a backup before starting)
miércoles, 11 de abril de 2012 22:28
I need to move everything that is on the D: onto a new 1TB external hard drive.
You may need to be aware of this, if the new drive is removable http://msdn.microsoft.com/en-us/library/ms143547(v=sql.105).aspx
'Program files and data files cannot be installed on a removable disk drive...'
You could move the files onto the D drive, but depending on the external drive connection i.e. if you use a USB2 port, then performance will likely be pretty bad due to limited throughput.
- Marcado como respuesta Iric WenModerator jueves, 03 de mayo de 2012 8:19
jueves, 12 de abril de 2012 13:35Javier, thanks for your input, however, you tell me I can, and KevinNocholas's link to msdn article states that I cannot:/. Please let me know my foreshore options on this task as this is considered critical.
jueves, 19 de abril de 2012 4:16I would not be moving to an external drive as it would not be fast enough to run SQL Server.
martes, 01 de mayo de 2012 9:35
Hi you can also ask your query on the given link, it may help you for the same.
miércoles, 02 de mayo de 2012 10:06Moderador
Moving the files to a removable drive is not prohibitted but is not be suggested by Microsoft.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.