Viewing 15 posts - 46 through 60 (of 162 total)
its unlikely to shrink while there is an active connection, try disabling the account that's connecting and try again. Ensure you are aware of the impact of doing that...
May 24, 2013 at 5:35 am
dineshvishe (5/24/2013)
1)Check you should full access on \\CONFERENCE-PC\PrimaLink Share\Pratip.2) create text file and delete for test purpose.
3) Once you have right then take backup.
point 2 would only be valid if...
May 24, 2013 at 5:27 am
Paul Treston (5/24/2013)
I have a database where we have archived and purged 95% of the data, leaving a 230GB file where only 7GB of it is in use by...
May 24, 2013 at 4:12 am
Funnily enough I've just had a similar problem but with a local backup path. I had to add the sql ENGINE service account to the backup folder not the...
May 24, 2013 at 3:35 am
niladri.primalink (5/24/2013)
Yesterday I installed 2012 and trying to know its features. Here I am facing a problem. I am trying to take back up of my AP database in...
May 24, 2013 at 3:03 am
Great article! Some really good pointers there!
May 24, 2013 at 2:12 am
sqlfriends (5/23/2013)
Loundy (5/23/2013)
May 24, 2013 at 1:23 am
Did you physically install 4 instances (all with different names)? or did you install an instance on node A then add the instance on Node B (for both instances)...
May 23, 2013 at 8:41 am
Have you tried a different set of binaries? I've had issues before with the binaries I was using so used a different set and it worked ok.
May 23, 2013 at 8:37 am
unfortunately downgrade isn't possible.
you could install standard next to enterprise and copy the dbs to it before uninstalling to minimize any downtime, but as mentioned, back your dbs up first...
May 23, 2013 at 8:33 am
ramyours2003 (5/17/2013)
no space in data file , unable to shirnk.
You need to purge some old data first - whether that is permanently deleting it or moving it to another db...
May 17, 2013 at 8:44 am
Eugene Elutin (5/17/2013)
ramyours2003 (5/17/2013)
We donot have space in database ,and the disk is fulled because of mdf's . how to release space on the driveDelete something! 😉
ROFL - that...
May 17, 2013 at 4:50 am
Could you find the inserts / updates for this table and baseline the I/O, execution time for them WITH the indexes in place then baseline WITHOUT. Convert the figures into...
May 10, 2013 at 6:32 am
PREEMPTIVE_OS_AUTHENTICATIONOPS could indicate problems talking to a domain controller - not personally experienced this though.
May 10, 2013 at 1:17 am
In future versions of sql server the ; will be compulsory after a statement too I believe.
May 10, 2013 at 12:39 am
Viewing 15 posts - 46 through 60 (of 162 total)