Forum Replies Created

Viewing 15 posts - 46 through 60 (of 507 total)

  • RE: Do We Need a PK?

    The only time I have ever seen a regular database structure that is logically defined but not physically enforced with keys (PK,FK) is in CRM/ERP applications. The number one reason...

  • RE: Threads

    you will have to syncronize or serialize the calls in some way shape or form. http://www.codeproject.com do a search on lock, syncronziation or serialization. I don't do vb at all...

  • RE: Use Red-Gate''''s backup... and Go to Jail???

    In the fairness of "Full Disclosure" I also use to be the product manager for LiteSpeed.

    I think this was mishandled all the way around. Bob was trying so hard to...

  • RE: SQL database protection for SQL Dummies...

    SQL Server 2000 Backup and Recovery Osborne Press by Desai 213027-x is thier product number.

    Cheers,

    Wes

  • RE: Transaction Log Backup during Full backups

    This is a limitation in SQL Server 2000. We call it the backup black hole. In 2005 you can do a tlog while a full is in progress to keep...

  • RE: How to find all the SQL servers within a domain

    osql - L doesn't cross subnets so as long as your domain doesn't cross subnets and you haven't changed the default ports it should give you a pretty accurate list.

    Wes

  • RE: TempDB BottleNeck ?

    Sharing spindles with other apps is a huge killer on san's and is much more common on the ones that do virtualization you tend to get hot spots and you...

  • RE: Fastest Table Transfer

    drop indexes bcp the data out and back in or drop the table and do a select * into table

    both can be non-logged operations and that is where you get...

  • RE: VDI - Phyiscal File Creation Performance

    There is nothing in sql 2000 you can do to speed up the creation of the data files to disk on a new restore or restore with replace. the deal...

  • RE: What happened to LogPi product?

    As far as I know it is no longer being actively developed or sold. If you have a support question and can't find an answer let me know I know...

  • RE: Cannot Open the Database

    One,

    no other service/person can be accessing the files at all.

    if you want to use the share you will have to enable the correct trace flag so sql server will...

  • RE: Help me understand FileGroup Backups & Restore.

    You restore the filegroup that you need to restore then all the logs after that filegroup backup. If you don't have a tlog to restore you cannot complete the file...

  • RE: How is LiteSpeed for SQL Server Database Backups

    I apologize about your customer service experience. We are working hard to resolve it. There was an issue discovered early on in the 4.5 release where under specific conditions a...

  • RE: How is LiteSpeed for SQL Server Database Backups

    Well, the latest version 4.6 is the fastest, most stable, and reliable version that has ever been released. It has several thousand users world wide. I can tell you we...

  • RE: Backup database fails

    sorry wasn't paying close enough attention you can't modify the maint plan statement for backups.

    Who is the owner of that database?

    Has it been restored to that server in...

Viewing 15 posts - 46 through 60 (of 507 total)