Comments
Sort by recent activity
Yes I did. The ABC_ARCHIVE database data file is 771GB and log file is 18 GB - which is the same size as the ABCPROD database on the day the backup was taken.
To rule out the hard disk space (at first I thought it was the hard disk space issue failure); I still have 2.8 Terabytes on that drive where the data & log files are located. / comments
Yes I did. The ABC_ARCHIVE database data file is 771GB and log file is 18 GB - which is the same size as the ABCPROD database on the day the backup was taken.
To rule out the hard disk space (at fi...
Used GUI - but, this is in the Activity Log - db name changed for forum posts.
SQL Backup log file 7.0.5.1
-SQL "RESTORE DATABASE [ABC_ARCHIVE]
FROM DISK = '\\servername\foldername\foldername\ABCPROD_FULL_20130109.bak'
WITH NORECOVERY, DISCONNECT_EXISTING,
MOVE 'ABCPROD_Data.MDF' TO 'F:\Datafiles\ABC_ARCHIVE_Data.MDF',
MOVE 'ABCPROD_Log.LDF' TO 'F:\Logfiles\ABC_ARCHIVE_Log.LDF',
REPLACE " / comments
Used GUI - but, this is in the Activity Log - db name changed for forum posts.
SQL Backup log file 7.0.5.1
-SQL "RESTORE DATABASE [ABC_ARCHIVE]
FROM DISK = '\\servername\foldername\foldername\ABCPR...
If you meant this thread http://www.red-gate.com/messageboard/vi ... norecovery
the thread OP got an error. I do not have an error. In fact, the Activity Log reports restore process completed successfully. However, on both SQL Backup and SSMS, that particular database has the status "restoring ...". And it has been there for 2 days; but the SQL Backup suggests the restore completed successfully in about 1 hour and 27 mins. / comments
If you meant this threadhttp://www.red-gate.com/messageboard/vi ... norecovery
the thread OP got an error. I do not have an error. In fact, the Activity Log reports restore process completed succes...