When you are restoring large STSADM backup file, make sure that you have sufficient Log and Data disk space on SQL server. Presize SQL database to the size of STSADM backup and make sure that your LOG drive has as least four (4) time the size of STSADM backup size or your backup will fail with "operation failed" error.
Why do you so much disk space on SQL server? During STSADM restore, wedecompreses all files all files stored in STSADM dat file, so you LOG file will grow at leaset 3-5 times the size of STSADM backup file.
No comments:
Post a Comment