Viewing 15 posts - 38,101 through 38,115 (of 49,571 total)
Either you have a maintenance plan option that's doing a shrink or you have autoshrink on or there's a manual shrink job somewhere.
June 29, 2009 at 5:28 am
You will not be able to see the corrupted pages even with DBCC Page. They're damaged, SQL won't read them. Besides, from looking at the errors, it looks like a...
June 29, 2009 at 5:21 am
Switch it to bulk-logged. If you switch to simple you'll be breaking the log chain and will need to do a full backup after switching back to full.
June 29, 2009 at 4:52 am
Disaster recovery? What's that?
I'm almost ready to stop asking if people have backups when they post corruption questions. It's a waste of time.
June 29, 2009 at 4:51 am
hi_abhay78 (6/29/2009)
First take the database into emergency mode and then try to rebuild the index .
Emergency mode is for recovering a database that's suspect.
June 29, 2009 at 4:49 am
Compatibility mode 80?
Edit: Never mind. Ignore this. I misread the forum this was in.
June 29, 2009 at 4:48 am
venu_ksheerasagaram (6/29/2009)
2)Is the differential backup depends on the full backup file?
No, but you need both to restore a database
3)Suppose the full backup of the DB is not existed (or) moved...
June 29, 2009 at 4:47 am
Rebuild's not going to help. There's damage to the clustered index (ie the table itself). That's not redundant data hence there's nowhere for an index rebuild to read the damaged...
June 29, 2009 at 4:46 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
June 29, 2009 at 4:44 am
Ramji (6/29/2009)
I need a script which should take a integer as input parameter(time in minutes), and should query sysjobs, sysjobhistory to check whether there is a mintanence window possible...
June 29, 2009 at 4:36 am
Grant Fritchey (6/29/2009)
You're right about the DROPCLEANBUFFERS and FREEPROCCACHE.
Personally I prefer to run all test queries twice and ignore the times of the first result. That way, what I'm seeing...
June 29, 2009 at 4:29 am
keil.asta (6/28/2009)
June 28, 2009 at 12:18 pm
Well, first you need to tell us what you consider to be the 'first' value. Tables have no order, so any row is equally valid as the 'first'
Why would row...
June 28, 2009 at 11:54 am
Then you should use the execution time from statistics IO or the duration from profiler as it includes all the times that SQL had to wait while executing that query....
June 28, 2009 at 11:48 am
Are things like IO latency (when fetching data off disk), lock wait times and the like relevant, or are you just looking for the amount of timethe queries spent executing...
June 28, 2009 at 10:57 am
Viewing 15 posts - 38,101 through 38,115 (of 49,571 total)