Forum Replies Created

Viewing 15 posts - 181 through 195 (of 210 total)

  • RE: Transaction log backup - A silly question

    I suppose its possible they created this job in order to protect against a failed backup.  Perhaps if a full backup failed, their log would fill up before the next...

  • RE: Restoring incomplete backup file

    LiteSpeed for SQL Server (from Imceda software) supports object level recovery.  Using this product you will be able to restore individual tables from a full backup file (native or compressed...

  • RE: Upgrades SQL2k sp3 from Windows 2K to Windows 2003

    The only issue I have run into when upgrading from Win 2000 to Win 2003 is regarding the OLEDB.dll driver not being correctly upgraded.  This typically only reers its ugly...

  • RE: Double Take?

    I'm not very familiar with Double-Take but I believe it is an implementation of snapshot technology.

    Snapshot technology as a whole is fantastic for high availability and for instantaneous backups, however...

  • RE: Backup time increased by 1 hour

    Definitely sounds like a hardware issue associated with the drive you are reading/writting from.  Is it possible to try writting to a different local drive on a completely different drive...

  • RE: restore file space

    Most likely this is because your database has 75 gigs allocated to it.  If you have 75 gigs allocated for your tlog and data file, when you restore it will...

  • RE: Making a backup to a remote machine

    If you don't want to backup using drive mappings you should use UNC path naming conventions.  SQL server handles these much better than mapped network drives.  All you need to...

  • RE: How does T-Log backup work?

    Make sure you see if your TLog file is configured to autogrow.  Even though this causes MAJOR performance hits if you reach this threshhold, it will atleast not cause a...

  • RE: How to remove old Backup Files

    One way that I've used is to include a datetime stamp in the filename and then delete the files based on parsing out the filename from the file then doing...

  • RE: View / Log all queries coming into SQL Server 2000 database

    Be careful with Profiler.  Microsoft has stated that they cannot guarantee that all transactions are captured with profiler.  Especially during periods of high activity, some transactions may be lost.  If...

  • RE: Why do they make it difficult

    Scott,

    You should look at log shipping solutions.  These are very simple to set up and do a good job of keeping databases in sync within a specified time interval.  Log...

  • RE: Bug in sp_ShipLog in SLS ?

    It looks like your referring to the LiteSpeed simple log shipping scripts.  We do not provide a procedure called sp_logship but do have simple log shipping scripts and an @hourduration...

  • RE: Backing up SQL SVR 7/2000 to a mapped network drive

    SQL Server is real picky about how it handles mapped drives. I've found that the easiest way to handle network drives is to use UNC naming conventions. Even...

  • RE: Updates during a Database backups

    I believe the scenario is that during a full backup first the .MDF file is backed up and then at the end of a full backup a log backup is...

  • RE: Microsoft Source Safe

    The product has actually just been acquired by Imceda Software and has really taken off. Please look to http://www.imceda.com for more info.

Viewing 15 posts - 181 through 195 (of 210 total)