Home Forums SQL Server 2005 Administering Copying Databases - Error - TempDB - Error: 823 Severity: 24 State: 7 RE: Copying Databases - Error - TempDB - Error: 823 Severity: 24 State: 7

  • Copying was an easy way to make a replica of another test database. Because we don't backup every database, if I didn't do a copy, I would have to make a backup and then do a restore. I realize this isn't a big deal but I found the copy functionality (as I'm a DBA in training) and wanted to try it out. If it's not a good idea, I'll make that recommendation going forward but in the meantime I ran into these errors. I'm concerned that there may be some underlying problem with one of our drives (as this is a brand new server) but if the copy feature is unreliable, I can attribute it to that and move on.