Viewing 15 posts - 16 through 30 (of 110 total)
Solution found!
It turned out for mount points there are two 'security' tabs that you can set up access rights for different accounts.
Please see attachment "old_security_tabl.jpg": the first 'security' tab from...
July 20, 2011 at 5:36 am
Perry Whittle (7/20/2011)
July 20, 2011 at 5:08 am
Jayanth_Kurup (7/20/2011)
http://www.sqlservercentral.com/Forums/Topic366456-357-1.aspx#bm1035748%5B/quote%5D
I've checked this post before I even put up this one.
It didn't help.
July 20, 2011 at 5:06 am
GSquared (7/19/2011)
Is that a local drive, a SAN, a network drive, something else?
It is a volume mount point from SAN.
July 20, 2011 at 1:23 am
Jannie-186227 (7/19/2011)
The user that you are using don't have access to the file system.Grant yourself relevenat permissions on the drive you want to create the DB on.
Cheers
Jannie
I am using remote...
July 20, 2011 at 1:20 am
cfradenburg (7/19/2011)
I don't see a response to...
July 19, 2011 at 4:05 pm
ALZDBA (7/19/2011)
just my 2ct:Is this on a cluster ?
Did you create the dependency for the S drive for your sqlserver instance ?
Not a cluster.
July 19, 2011 at 10:51 am
GilaMonster (7/19/2011)
sqlapprentice (7/19/2011)
And I am sure both SQL Server service account and SQL Server agent service account have full control privileges on both folder 'S:\SQL\userdbdata01\' and 'S:\SQL\userdblog01\'.
Do you think you're...
July 19, 2011 at 10:50 am
Just one more thing to add, I've read the Microsoft bug fix article (http://support.microsoft.com/kb/272220/EN-US/) regarding incorrectly reclaiming space from a table with text or image columns but it...
May 19, 2011 at 2:08 am
TheSQLGuru (5/18/2011)
May 18, 2011 at 3:08 pm
TheSQLGuru (5/18/2011)
Hope you are aware that when you defrag your indexes the size of your database will expand back out some.
Could you please explain briefly why filling up all the...
May 18, 2011 at 12:43 pm
TheSQLGuru (5/18/2011)
sqlapprentice (5/17/2011)
Steve Jones - SSC Editor (5/16/2011)
This (http://www.sqlservercentral.com/Forums/Topic993883-146-6.aspx#bm1008735) seems to indicate this is by design. I would shrink the file, looking to deallocate the LOB extents.
I finally solved this...
May 18, 2011 at 11:15 am
Steve Jones - SSC Editor (5/16/2011)
This (http://www.sqlservercentral.com/Forums/Topic993883-146-6.aspx#bm1008735) seems to indicate this is by design. I would shrink the file, looking to deallocate the LOB extents.
I finally solved this issue by...
May 17, 2011 at 1:49 am
Steve Jones - SSC Editor (5/16/2011)
Hmmm, not sure about image. Have to look it up, but I'd guess sp_spaceused is broke.Did you delete a lot of the image data?
yes, I...
May 16, 2011 at 9:47 am
sqlapprentice (5/16/2011)
Steve Jones - SSC Editor (5/16/2011)
May 16, 2011 at 9:46 am
Viewing 15 posts - 16 through 30 (of 110 total)