Forum Replies Created

Viewing 7 posts - 61 through 67 (of 67 total)

  • RE: Duplicate a table/view

    Bulk insert with tablock hint will improve performance.

    Still several factors to be considered, physical placements of data, index, tempdb files, fast disk subsystem..etc.

  • RE: Log Shipping

    I still remember I also had a bizaare problem in the past with log shipping getting out of sync which has something to do about the dates not being updated...

  • RE: Remove data base file fragmentation?

    Yes, data files can also be fragmented. You need to use a defrag software to defrag it like any other operating system files.

  • RE: SQL backup with Block-Level technology

    It is a good practice to pre-allocate your tlog size, but you may want to leave it to auto-grow (unless you do not have plenty of disk space), otherwise you...

  • RE: differential backups

    There are tons of scripts out there, make sure you pick out one that accepts parameters like dbname, or all databases, or user/system databases, and the cleanup task (file retention)...

  • RE: SQL backup with Block-Level technology

    If you're recoverability requirement is point in time recovery, you'll need it in full mode. Keep your tlog backups as often as possible. You don't need to truncate the tlogs.

  • RE: Restore Database missing LOG from FileGroup

    That was a filegroup backup, restore it using a filegroup restore. They sent you that part, probably because the data you need is all in that filegroup. If you...

Viewing 7 posts - 61 through 67 (of 67 total)