Viewing 15 posts - 106 through 120 (of 131 total)
All the Indexes are non-unique & non-clustered.
May 11, 2011 at 7:59 am
No primary key on the table . 1 foreign key.
May 11, 2011 at 7:53 am
All indexes (12 indexes) are non-unique & non-clustered.
10 out of 12 indexes are of Decimal(18,2) & 2 have INT on them.
This table is not heavy on inserts or updates. Total...
May 11, 2011 at 7:44 am
No. Auto shrink is off & no shrinks applied as of now.
There is a correction: I had mentioned 18 tables. It should be 18 Indexes. and the Indexes are...
May 11, 2011 at 7:36 am
I tried the shrink option on my test server & the file size came down to 4.5GB.
May 11, 2011 at 5:48 am
yes, i backup transaction log every hour.
May 11, 2011 at 5:46 am
I have another issue.
We wanted to backup the data from our production server to our test server for test purposes. But the issue is that the test server runs...
May 11, 2011 at 5:27 am
On 7th the Data File size was 12 GB & the Log size rocketed from 4 MB to 2.7 GB. I Detached the database & moved the Log File. Attached...
May 11, 2011 at 1:28 am
Thanks a lot for the time taken to answer my query:-):-):-):-)
May 10, 2011 at 9:36 am
Thanks a lot for the valuable suggestion!!!!!!!:-):-):-)
May 7, 2011 at 4:01 am
Thanks a lot!!!!!!!! for the invaluable suggestion:-):-):-):-):-)
May 6, 2011 at 9:15 pm
No operations were performed. All jobs are scheduled towards the End Of Day.
May 3, 2011 at 4:44 am
Date,Source,Severity,Message
05/02/2011 23:00:10,Backup,Unknown,Log was backed up. Database: This is an informational message only. No user action is required.
May 3, 2011 at 4:16 am
Database Size:10,417 MB Space Used:10238 MB
Log File Size: 1,524 MB ...
May 3, 2011 at 3:47 am
Viewing 15 posts - 106 through 120 (of 131 total)