December 2, 2015 at 6:15 am
Stewart "Arturius" Campbell (12/2/2015)
tom.w.brannon (12/2/2015)
I don't deal with this level of the db but it seems like a trick question. At https://msdn.microsoft.com/en-us/library/ms190940.aspx it states 'These files are located in <drive>:\Program Files\Microsoft SQL Server\MSSQL<version>.<instance_name>\MSSQL\Binn\ and should not be moved'. 'Should not' is less restrictive than 'Cannot'. The specification that the drive is a variable would seem to indicate that different drives can be used. The name of the folder seems fixed for a database. I took the 'or' as if either is true then the whole thing is.Strange, according to this, it states "cannot be moved"?
Yes, the documentation is contradictory. You definitely shouldn't move it, whether you can or not, because it's not supported.
December 2, 2015 at 6:44 am
I guessed wrong.
December 2, 2015 at 7:04 am
December 2, 2015 at 7:07 am
Stewart "Arturius" Campbell (12/2/2015)
tom.w.brannon (12/2/2015)
I don't deal with this level of the db but it seems like a trick question. At https://msdn.microsoft.com/en-us/library/ms190940.aspx it states 'These files are located in <drive>:\Program Files\Microsoft SQL Server\MSSQL<version>.<instance_name>\MSSQL\Binn\ and should not be moved'. 'Should not' is less restrictive than 'Cannot'. The specification that the drive is a variable would seem to indicate that different drives can be used. The name of the folder seems fixed for a database. I took the 'or' as if either is true then the whole thing is.Strange, according to this, it states "cannot be moved"?
Just read your link and it says "should not be moved".
What version were you looking at?
December 2, 2015 at 7:07 am
December 2, 2015 at 7:19 am
It used to be possible to move it, and as I recall had to be in the same folder as the master database. It can't be moved any longer. The question could have made that more clear, although I assumed the most recent version in my answer.
December 2, 2015 at 7:45 am
PHYData DBA (12/2/2015)
Stewart "Arturius" Campbell (12/2/2015)
tom.w.brannon (12/2/2015)
I don't deal with this level of the db but it seems like a trick question. At https://msdn.microsoft.com/en-us/library/ms190940.aspx it states 'These files are located in <drive>:\Program Files\Microsoft SQL Server\MSSQL<version>.<instance_name>\MSSQL\Binn\ and should not be moved'. 'Should not' is less restrictive than 'Cannot'. The specification that the drive is a variable would seem to indicate that different drives can be used. The name of the folder seems fixed for a database. I took the 'or' as if either is true then the whole thing is.Strange, according to this, it states "cannot be moved"?
Just read your link and it says "should not be moved".
What version were you looking at?
This link says 'should not':
https://msdn.microsoft.com/en-us/library/ms190940.aspx
This link says 'cannot':
https://msdn.microsoft.com/en-us/library/ms345408(v=sql.130).aspx
Both refer to SQL Server 2016, and it's the same for 2014.
December 2, 2015 at 8:32 am
Thanks for the question - this is good to know.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 2, 2015 at 10:22 am
Seems that you can't or shouldn't depending on which link and/or version you are using. As always we need to assume the most current version but the documentation is contradictory and the can't seems to be proven otherwise. Seems that both answers are correct to this question. But of course, it is consistent that it is not a good idea and that it isn't supported.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 2, 2015 at 12:38 pm
I have moved the resource database in previous version of SQL Server. Although, I do not recall if it was 2005 or 2008. I found an interesting quirk after it was moved. If you install a service pack, the location of the resource database will revert back to the original location.
December 2, 2015 at 12:52 pm
Robert Eder (12/2/2015)
I have moved the resource database in previous version of SQL Server. Although, I do not recall if it was 2005 or 2008. I found an interesting quirk after it was moved. If you install a service pack, the location of the resource database will revert back to the original location.
Which is why I know you can and that M$ actually does support this and has applications that do this.
DPM and other Datacenter Edition products do move this database and have to "find" it again after any SP or other update to SQL or the Datacenter product.
December 3, 2015 at 9:38 am
But that wasn't what the question states.....technically, it can be moved. Realistically, that isn't a very good option.
December 7, 2015 at 3:35 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 7, 2015 at 3:35 am
PHYData DBA (12/2/2015)
Which is why I know you can and that M$ actually does support this ...
Just curious, do you also use Appl€?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 8, 2015 at 3:30 am
Koen Verbeeck (12/7/2015)
PHYData DBA (12/2/2015)
Which is why I know you can and that M$ actually does support this ...Just curious, do you also use Appl€?
What about Son¥?
Viewing 15 posts - 16 through 30 (of 30 total)
You must be logged in to reply to this topic. Login to reply