Viewing 15 posts - 196 through 210 (of 307 total)
If I remeber right from my days at Microsoft, Log shipping was developed as an internal solution by a a couple of DBA's/ developers to handle their bus. needs. How...
March 12, 2003 at 7:45 am
Yes and no, If you leave your database in read only mode you can use it for reporting/querying. The problem, when log shipping goes to apply the next transaction log...
March 12, 2003 at 7:39 am
I have this exact scenario and have thoroughly tested it with great success. I prefer to rebuild the production server and reset the failover, mainly because the failover server is...
March 12, 2003 at 7:30 am
The ice has melted, the fog is lifting.
Thanks guys,
John Zacharkan
March 5, 2003 at 11:12 am
Everyhting you wrote is fabulous and sincerly apprecative, but my Jersey brain is still frozen from this most miserable winter here. I still don't get how to execute the dbcc...
March 5, 2003 at 10:25 am
I can see where and how you would manage this manually. Were you able to automate it and if so how? Would you mind sharing.
March 5, 2003 at 8:09 am
I run .net and SQL Server 7 on my laptop, with backups from our dev site restored weekly. Not at all complicated in setting up.
February 28, 2003 at 11:21 am
My problem (at the moment) with the dedicated ftp server is that I then need two dedicated ftp servers. I cannot afford to have any single point of failure.
I...
February 28, 2003 at 10:30 am
Is there risk in installing it in this manner?
quote:
- If you only need FTP, you can choose not to install WWW and...
February 27, 2003 at 11:20 am
I am playing devils advocate, but I need a better convincing argument. Personally I think IIS should never be on the same server regardless of whether you are using it...
February 27, 2003 at 10:07 am
Any gottchas with installing IIS on the database server (security concerns). We need it only for FTP. Our is behind a Firewall, on a seperate segment, we need FTP to...
February 26, 2003 at 2:22 pm
I'm assuming that you ask this because something went wrong with the load. How many licenses, is the database in sql user mode or dbo use only?
February 25, 2003 at 2:04 pm
Thank you Antares686 for sharing how and when you use pintable.
From a design point of you I agree with you Andy, going forward I'm sure I'll be in on...
February 24, 2003 at 1:24 pm
I'm in NJ as well, at least the snow kept some of the users home.
What raid configuration did you go to? Did this alone account for the performance gain?...
February 19, 2003 at 11:24 am
'grow transactional log automatically' - This is okay as long as you procatively monitor your disk and transaction log space.
'truncate log on checkpoint' - If you lost your databse...
February 19, 2003 at 10:37 am
Viewing 15 posts - 196 through 210 (of 307 total)