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

  • Lowell (2/15/2013)


    ok, in that case, it might be that the tempdb is running out of space or something for the import wizards process?

    i'd still recommend backup and resotre over the copy database wizard.

    The weird thing is that out of the six database I've attempted to copy, four worked. Those four range in size from a few gb to 300 gb. The two databases I am copying are about 40 gb and 200 gb but only these two fail.

    TempDB has plenty of space.