Viewing 15 posts - 526 through 540 (of 615 total)
I didn't mean 10GB increments for auto growth. I meant large "manual" increases in file sizes done during a maintenance window to get plenty of free space in the...
June 13, 2008 at 12:04 pm
Yes I'll need to estimate expected growth in both the data file and the tlog file and size those up in advance of the conversion. I don't have...
June 13, 2008 at 11:22 am
Thanks for all of the information. I've passed it on to management here. No response yet ( I didn't get a response when I brought this to their attention...
June 13, 2008 at 6:26 am
When you add a data file to the source database along a path which does not exist on the standby server, the transaction log won't restore. You have to...
June 6, 2008 at 10:17 am
I'll test this to see if the mdf grows as you indicated. I also need to test to see how log shipping handles partitioning of a table. Have...
June 6, 2008 at 8:33 am
In a test area I set up log shipping, then added a data file ( ndf ) to the primary file group. It appears this transaction was log shipped...
June 6, 2008 at 8:23 am
How quick is very quick on the hourly full backup using netapp tools ( not tape backup)? Currently with log shipping we do a full backup every night with...
May 2, 2008 at 6:51 am
It's Netapp's snapmanager and snapmirror products. From what I'm reading, you take a full backup with this technology perhaps every hour with "incremental" transaction log style backups more frequently...
May 1, 2008 at 6:41 am
At my company the new product is being developed by a separate team that subscribes to the agile development concepts. While I wouldn't say they are "religious" about...
April 26, 2008 at 6:56 am
It's a sql 2005 Enterprise active/passive cluster with key files stored on leased SAN space. We are in the process of getting our own SAN. The standby log...
April 23, 2008 at 4:10 pm
We're using something like the following. Switching to LIMITED sampling might help a bit with the run time on the initial cursor creation, but it's really the one large...
April 23, 2008 at 2:05 pm
No responses on this topic yet. Today's editorial deals with it. Perhaps the topic is too new or just doesn't touch DBA-types where they currently live -- too...
March 17, 2008 at 8:13 am
Well I can't imagine Microsoft teaching or advocating anything that would incline one towards switching away from SQL Server, so it must be some pointy-headed professors in CS classes. ...
February 21, 2008 at 8:54 am
ok. I thought having business logic stored on the database server ( in procs ) was not agile. The ultimate of agile being where you could switch to Oracle...
February 21, 2008 at 8:32 am
AndrewMurphy (2/21/2008)
...the stored procedure school being considered dinosaurs apparentlyplease shoot these uneducated hunters, or your organisation will encounter the ice-age.
That must be a vote for one school over the...
February 21, 2008 at 8:00 am
Viewing 15 posts - 526 through 540 (of 615 total)