Forum Replies Created

Viewing 15 posts - 286 through 300 (of 341 total)

  • RE: Third Party Backup / Restore

    You would most likely need to perform the restore of the full backup using the third party tool (if you are using features not found in the standard SQL Server backup), and...

  • RE: Identical simultaneaous Full and Trans Log Backups??

    SQL Server 2005 will be able to do this, writing up to 4 devices.  For SQL2K, our product, MiniSQLBackup, has 2 options for this:

    • simultaneous creation of the backup file(s) on all...
  • RE: Restore from Media Set

    Man, how could I have missed that? 

  • RE: Restore from Media Set

    I have never used the MEDIANAME option, and do not know the effects of doing so.  Why do you need to use the MEDIANAME option if you are backing up...

  • RE: Space requirement for Re-indexing.

    Assuming you are talking about running DBCC DBREINDEX on the clustered index, I recall from a document by Quest Software that SQL Server needs approximately 1.25 times the data space of...

  • RE: Bckup, Append or overwrite?

    1.  You could give our product, MiniSQLBackup, a try.  It can generate smaller backups for you.

    2.  If you set to overwrite, that means you will only have the latest backup.  If you...

  • RE: Restore from Media Set

    My guess is that server B does not have adequate rights to the other servers' folders.  Check your SQL Server startup service account.  It cannot be a LocalSystem account if...

  • RE: (De)fragmentation in case of a backup / restore

    He probably meant DBCC DBREINDEX.

  • RE: Backup Coming From Secret Location

    There's a possibility that the job may have been started remotely by someone with backup rights.  The next time the job runs, you could try running sp_who2 to see where...

  • RE: Restore from Media Set

    What's the error message?

  • RE: Restore from Media Set

    The suggestion provided by sa24 should work.

  • RE: Restore from Media Set

    SQL is writing a portion of the DB to all 3 devices.  Thus, you need all 3 files when you perform the restore.

    SQL 2005 will support mirrored backups.  If you...

  • RE: Restoring a database...

    There isn't any additional space requirements, other than that to contain your database.

    Is there a possibility that the data folders on both servers are different?  If you restore a database...

  • RE: Primary key Clustered or Clustered Index?

    >>  A non-clustered index holds pointers to the data int he leaves of the index.

    And to clarify a little more, if a table does not have a clustered index, this...

  • RE: Primary key Clustered or Clustered Index?

    Strange question to be posted in the Backups group ....

    Anyway, a primary key is a primary key (unique).  A clustered index means the physical order of the data is sorted...

Viewing 15 posts - 286 through 300 (of 341 total)