Viewing 15 posts - 36,331 through 36,345 (of 49,562 total)
Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 14, 2009 at 1:05 am
SQLRocker (10/13/2009)
Auto-shrink is enabled.
Disable it and try the manual shrink again. It could be that you're trying to shrink while the auto-shrink is running, hence the error that the...
October 14, 2009 at 12:50 am
Krasavita (10/13/2009)
How to check for space for a Log File
Error log, event log, maintenance plan history log, transaction log???
Assuming you mean transaction log, do you want the size of the...
October 13, 2009 at 10:08 am
Silverfox (10/13/2009)
my build version is 9.0.4035
That the server version or management studio version?
October 13, 2009 at 10:05 am
Auto-shrink enabled?
Why are you shrinking the database? Do you expect that the 15 GB free space won't be reused in a reasonable amount of time?
October 13, 2009 at 8:40 am
Don't rebuild indexes that don't need rebuilding. There are lots of custom index rebuild scripts available. There's one I quite like here - http://www.sqlfool.com
October 13, 2009 at 3:19 am
Joseph Fallon (10/13/2009)
Is this a new "feature" in 2008 I wonder ?
No. It was there in 2005 as well. That's where I ran into it.
October 13, 2009 at 3:11 am
Silverfox (10/13/2009)
Interesting, I backup and restore "copy only" backups all the time, never had any issues.
T-SQL restore statement or Management studio restore dialog?
It was a known problem on SQL 2005...
October 13, 2009 at 1:32 am
pramod_yg (10/13/2009)
Is there no way, i mean any add on's installation all all would help to achieve it?
You can buy SQL Prompt from RedGate. It's around $300 iirc. In my...
October 13, 2009 at 1:23 am
Free-292871 (10/12/2009)
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly...
October 13, 2009 at 1:20 am
tvanharp (10/12/2009)
I found that I can't restore the backup created with the copy only clause in mgnt studio.
Known bug. Can't recall if there's a connect item opened for it...
October 13, 2009 at 1:17 am
Joseph Fallon (10/12/2009)
The SQL Service user is in the Admin group on the server so should have ample rights ?
Not necessarily. It's possible to deny to an administrator
@Jeffrey I'll try...
October 13, 2009 at 1:15 am
gking-756277 (10/12/2009)
I installed SQL Server 2008 and BIDS.
So you have not purchased and installed Visual Studio?
BIDS is only the business intelligence projects. Unless you have also purchased and installed...
October 12, 2009 at 12:37 pm
Did you install Visual Studio 2008, or did you install BIDS from the SQL installer?
If you just installed BIDS, there's no C# projects included.
If you have full-blown visual studio...
October 12, 2009 at 11:59 am
Assuming that this is a clustered SQL Server....
The drives have to be added as a dependency to SQL. This is done in cluster administration.
Ask the server admin (assuming he...
October 12, 2009 at 11:08 am
Viewing 15 posts - 36,331 through 36,345 (of 49,562 total)