Viewing 15 posts - 13,861 through 13,875 (of 49,552 total)
Would this be the database in question?
03/15/2013 07:56:41,spid21s,Unknown,Unable to open the physical file "P:\DB\Prolaw.mdf". Operating system error 3: "3(The system cannot find the path specified.)".
03/15/2013 07:56:41,spid21s,Unknown,Error: 5120<c/> Severity: 16<c/> State:...
March 15, 2013 at 5:03 pm
Lynn Pettis (3/15/2013)
March 15, 2013 at 4:09 pm
dcyoung (3/15/2013)
My network guy is thinking it might be that sql server is starting befor ISCSI gets its job done.
Very possible, which is why I want to see the SQL...
March 15, 2013 at 4:02 pm
Exactly what it says, all logical log files are in use, so there are no empty ones. No empty VLFs = no shrink.
Check log_reuse_wait_desc in sys.databases for why the log...
March 15, 2013 at 4:01 pm
dcyoung (3/15/2013)
No errors and the same informational messages on my servers that don't have this problem.
Can you post the error log, from startup to the time you offline/online the DB?...
March 15, 2013 at 3:48 pm
SQLCrazyCertified (3/15/2013)
I thought it should truncate the inactive logs after logbackup\shrink are done.
Just like any other database in full recovery, the logs are truncated (marked as reusable) when a log...
March 15, 2013 at 2:55 pm
That'll be a scheduled job to run on whatever interval you want and update the relevant rows. You're right, this is not for a trigger. A trigger is for when...
March 15, 2013 at 2:00 pm
If it's allocation contention, doesn't matter how many drives the data files are split over, just the number of files. If you have IO contention that's when you need separate...
March 15, 2013 at 1:57 pm
I think someone is several miles out of his depth here...
http://www.sqlservercentral.com/Forums/Topic1430383-2799-1.aspx
p.s. I know he needs to partition by date, not region. Trying to get him to realise that as well...
March 15, 2013 at 1:39 pm
ratheesh4sql (3/15/2013)
Yeah i am planning to do that way.Region wise partitioning:
1. RegionGroup1Current,
2. RegionGroup2Current,
3. RegionGroupCurren
So, when you archive, you archive (move to another table) and delete an entire region at a...
March 15, 2013 at 1:36 pm
cryovenom (3/15/2013)
I'll try setting it to default for memory allocation and see if that goes away.
Will be interesting to see, but memory allocation is the one thing you do...
March 15, 2013 at 1:28 pm
2013-03-15 15:10:15.10 Server Failed allocate pages: FAIL_PAGE_ALLOCATION 1
That's memory related, might have something to do with the NUMA node configuration, not sure though.
Going to have to consult an expert...
March 15, 2013 at 1:16 pm
MyDoggieJessie (3/15/2013)
March 15, 2013 at 1:09 pm
cryovenom (3/15/2013)
Can you offer any assistance, despite the fact that you don't recommend this configuration?
If you post the error log that I asked for, maybe.
March 15, 2013 at 1:05 pm
ratheesh4sql (3/15/2013)
I want to create 3 partitions Based on the List of region
So the business rule is that you always archive and delete an entire region at a time....
March 15, 2013 at 1:03 pm
Viewing 15 posts - 13,861 through 13,875 (of 49,552 total)