Reply to thread

Message: <blockquote data-quote="Bumbzy" data-source="post: 20581469" data-attributes="member: 542692">Machanla...loku udauwak one...system eke database ekata danata differential backups wadina widiyata tama hadala tiyenne palleha tiyena script walin....Full backupDECLARE @MyFileName varchar(500)SELECT @MyFileName = (SELECT 'C:\Backup\Testing_' + REPLACE(convert(nvarchar(20),GetDate(),120),':','-') + '.bak'); BACKUP DATABASE [Testing] TO DISK=@MyFileName Differential backupDECLARE @Testing varchar(500)SELECT @Testing = (SELECT 'C:\Differencial\Testing_' + REPLACE(convert(nvarchar(20),GetDate(),120),':','-') + '_Differencial.bak');BACKUP DATABASE Testing  TO DISK=@Testing  WITH DIFFERENTIAL, INIT meke backups nam wadinawa eth restore karanna giyama error ekak denawa mokakda machanla mekata dena solution ekahodatama erila ban inne...meka tamai error ekaRestore failed for Server 'WIN-P78R2UR4HCH\SYSTOLICDBSVR'.  (Microsoft.SqlServer.SmoExtended)------------------------------ADDITIONAL INFORMATION:System.Data.SqlClient.SqlError: The log or differential backup cannot be restored because no files are ready to rollforward. (Microsoft.SqlServer.Smo)</blockquote>

Top Bottom