Viewing 15 posts - 976 through 990 (of 1,790 total)
I'm assuming that the recovery model is full for the database. Are you doing regular log backups in both locations? Same interval? If so, then log size should be relatively...
January 9, 2009 at 6:44 am
You're welcome.
Side note, I know there are some utilities that the SE's I used to work with used to change them all at once when we did this. Saved...
January 9, 2009 at 6:30 am
There may be a way to do it from SQL to Access but, I would make this a "pull" by putting some type of macro in Access that will pull...
January 9, 2009 at 6:26 am
Being that they are local then you are most likely running into a disk throughput issue. What is the disk configuration for your backups? If you are using SATA type...
January 9, 2009 at 6:23 am
On the active as this is going to be trying to connect / authenticate actively.
January 9, 2009 at 6:20 am
Jeff Moden (1/9/2009)
Are you sure those files aren't simply sitting in the trash bin?
Me thinks they are a mite big for the recycle bin, but I may be wrong. :w00t:
Samuel...
January 9, 2009 at 6:18 am
Agreed that you NEED to generate some test data so that you can get some size estimates and ultimately you will need some data so that you can do some...
January 8, 2009 at 9:49 pm
Ah, another huge benefit of working from home. I look out my window, watch the snow swirling, look at the ice and snow on the van and shudder as I...
January 8, 2009 at 9:36 pm
You might want to try posting this question here - http://asktom.oracle.com/pls/asktom/f?p=100:1:2761078594096133
This site is SQL Server people, not Oracle guys. 🙂
Who knows though, I get surprised all the time.......
December 31, 2008 at 5:04 am
I am totally unfamiliar with MOM outside of the general concept behind it so hopefully some others on this site can help. You might also want to check the MS...
December 31, 2008 at 5:01 am
When you say you have a text file is it literally named .txt? Can you open it with Notepad.exe? If the answer is yes to both these questions then you...
December 31, 2008 at 4:35 am
I would say that you are on the right track in finding your system slowness. 🙂 Typically the only way to alleviate disk IO pressure is to add disks to...
December 31, 2008 at 4:30 am
This appears to be a duplicate post. Also refer to post - http://www.sqlservercentral.com/Forums/Topic616876-146-1.aspx
December 31, 2008 at 4:25 am
Your questions were really answered by Jerry. It appears that you have LS configured in NORECOVERY mode which is not going to allow you to query the database to ensure...
December 31, 2008 at 4:23 am
Viewing 15 posts - 976 through 990 (of 1,790 total)