Viewing 15 posts - 916 through 930 (of 2,897 total)
If you don't absolutely need the space recovered, just leave it alone. The space is already allocated so when the table grows it won't need to allocate new space for...
May 16, 2011 at 7:54 am
Probably could go at the same time, but why ?
I run in series, not parallel:
Rebuild index
Rebuild index
backup t-log
Rebuild index
Rebuild index
backup t-log
May 16, 2011 at 7:51 am
I take transaction log backups very frequently inbetween reindexing steps to prevent big .ldf growth.
May 16, 2011 at 7:38 am
I think Backup & Restore would be the simplest method. You would need to resync the logins afterwards.
May 11, 2011 at 6:14 pm
In our production databases, transaction log backups are usually every 15 or 20 minutes.
From Gail's article above"
" If the database is in full or bulk-logged recovery model then log backups...
May 6, 2011 at 5:07 am
Some environments allow users and developers to run queries against production, or have development on the same server, or allow other application and processes to run on the production SQL...
May 4, 2011 at 4:54 am
How about Log Shipping ?
http://technet.microsoft.com/en-us/library/cc966381.aspx
Or did someone already mention it ?
May 3, 2011 at 12:14 pm
"SET ROWCOUNT" will be deprecated at some point, so I now use "DELETE TOP (2500) TableName"
May 3, 2011 at 12:08 pm
You could take full backups, & frequent differentials, and more frequent logs. Then you would restore the full, most recent diff, and just the logs since the diff. And...
May 2, 2011 at 3:19 pm
crainlee2 (5/1/2011)
We decided not to implement point-in-time recovery. Business requirements dictated that being up and online was more important than some data loss, so we use the Simple Recovery model...
May 1, 2011 at 9:08 pm
You could use a maintenance plan if you know the file extensions... Is that cheating ?
April 29, 2011 at 12:24 pm
Steve Jones - SSC Editor (4/28/2011)
April 28, 2011 at 12:10 pm
Ninja's_RGR'us (4/28/2011)
Himmat Singh (4/28/2011)
2) set the database recovery to simple - sp_dboption 'db_name', 'trunc. log on chkpt.', true
3) write a store produre to delete about 10000 per loop....
April 28, 2011 at 12:05 pm
Ninja's_RGR'us (4/26/2011)
The best alternative is to delete in smaller chunks and run tlog backups within the loop.
Yes, that is how I do it, with no problems. It also gives...
April 26, 2011 at 11:48 am
Viewing 15 posts - 916 through 930 (of 2,897 total)