Forum Replies Created

Viewing 15 posts - 196 through 210 (of 307 total)

  • RE: Log shipping VS Replication

    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...

  • RE: Log shipping VS Replication

    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...

  • RE: Log shipping VS Replication

    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...

  • RE: dbcc memorystatus & sysperfinfo

    The ice has melted, the fog is lifting.

    Thanks guys,

    John Zacharkan

  • RE: dbcc memorystatus & sysperfinfo

    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...

  • RE: dbcc memorystatus & sysperfinfo

    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

    #450317

  • RE: SQL off line??

    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.

  • RE: So What is IIS?

    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...

  • RE: So What is IIS?

    Is there risk in installing it in this manner?

    quote:


    • If you only need FTP, you can choose not to install WWW and...

  • RE: So What is IIS?

    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...

  • RE: So What is IIS?

    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...

  • RE: How does SQL Server treat multiple data loads?

    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?

  • RE: A Lookup Strategy Defined

    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...

  • RE: New Hardware HELL

    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?...

  • RE: transactional log keeps growing

    '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...

Viewing 15 posts - 196 through 210 (of 307 total)