Viewing 15 posts - 43,831 through 43,845 (of 49,571 total)
The account that SQL Server is running as (the SQL Server service account) needs to have permission to access that folder.
Check what accounts have permissions on that folder
Check what account...
October 14, 2008 at 1:37 am
Attach the database read-write, let it recover properly. Detach it again and then you should be able to attach it read-only without problems.
October 14, 2008 at 1:34 am
Your problem may also be poor indexing or poorly written queries. Both of those can easily cause SQL to have to read far more data than it should have to....
October 13, 2008 at 1:01 pm
Does this help?
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx
Basically, in my experience:
1) Log files on a separate RAID array
2) Data files (if there are multiple) on separate raid arrays
3) TempDB on its own set of dedicated...
October 13, 2008 at 12:54 pm
Can you post the table and index definitions please? Also the output of sp_spaceused for that table
October 13, 2008 at 12:45 pm
The only way that a SQL data or log file will decrease in size is if you explicitly shrink it or if you have autoshrink enabled (which is a bad...
October 13, 2008 at 12:43 pm
DBA (10/13/2008)
October 13, 2008 at 12:08 pm
David Lester (10/13/2008)
October 13, 2008 at 10:02 am
I'll add to that
7) Set up some performance monitoring so that you can establish a baseline of what's normal and what's not
8) Schedule index rebuilds/defrags as necessary
9) If in full...
October 13, 2008 at 10:01 am
wjones21 (10/13/2008)
No, not really any I/O bottlenecks.So, it's perfectly OK to eventually have a 1 TB single data file?
Usually before that point people will start splitting up, for recovery purposes....
October 13, 2008 at 9:57 am
That still only allows for a single row in inserted.
If multiple rows have been inserted, then your variable assignment (below) is going to assign values of one of those...
October 13, 2008 at 9:41 am
Looking at that, unless you're seeing IO bottlenecks (are you?) I doubt you'll see much if any improvement from the split. If you decide to split, then just add a...
October 13, 2008 at 9:03 am
Are you sure there's no one else with sufficient rights? Nothing got accidentally scheduled or run? The DTS package didn't perhaps have the wrong connection on a drop table task?
It...
October 13, 2008 at 8:58 am
thomas.lemesurier (10/13/2008)
This kind of works, except that in some cases there is more than one row in the Album table per album. For example, for a given album, the Album...
October 13, 2008 at 8:46 am
Viewing 15 posts - 43,831 through 43,845 (of 49,571 total)