SQL server database Differential backup problem need help guys

[Bumbzy]

Machanla...loku udauwak one...system eke database ekata danata differential backups wadina widiyata tama hadala tiyenne palleha tiyena script walin....

Full backup

DECLARE @MyFileName varchar(500)
SELECT @MyFileName = (SELECT 'C:\Backup\Testing_' + REPLACE(convert(nvarchar(20),GetDate(),120),':','-') + '.bak');
BACKUP DATABASE [Testing] TO DISK=@MyFileName

Differential backup

DECLARE @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 eka

Restore 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)

 

[G-Street]

machan uba gawa differentail backups sequece ekakata nath nam restore karanna ba,(point in time recovery).uba gawa full backup ekata passe sequece ekakata diff backups okkoma thiyanwanam puluwan.athara mada log backup damoth ewat restore karanna ona.
most impornt eka thama,,uba anthima .bak ekedi withari with recovery denna ona.previous ewadi with no recovery deepan. follow below steps

RESTORE DATABASE MyAdvWorks
FROM MyAdvWorks_1
WITH NORECOVERY;
GO
-- Now restore the differential database backup, the second backup on
-- the MyAdvWorks_1 backup device.
RESTORE DATABASE MyAdvWorks
FROM MyAdvWorks_1
WITH FILE = 2,
NORECOVERY;
GO
-- Now restore each transaction log backup created after
-- the differential database backup.
RESTORE LOG MyAdvWorks
FROM MyAdvWorks_log1
WITH NORECOVERY;
GO
RESTORE LOG MyAdvWorks
FROM MyAdvWorks_log2
WITH RECOVERY;
GO

 

[Bumbzy]

machan uba gawa differentail backups sequece ekakata nath nam restore karanna ba,(point in time recovery).uba gawa full backup ekata passe sequece ekakata diff backups okkoma thiyanwanam puluwan.athara mada log backup damoth ewat restore karanna ona.
most impornt eka thama,,uba anthima .bak ekedi withari with recovery denna ona.previous ewadi with no recovery deepan. follow below steps

RESTORE DATABASE MyAdvWorks
FROM MyAdvWorks_1
WITH NORECOVERY;
GO
-- Now restore the differential database backup, the second backup on
-- the MyAdvWorks_1 backup device.
RESTORE DATABASE MyAdvWorks
FROM MyAdvWorks_1
WITH FILE = 2,
NORECOVERY;
GO
-- Now restore each transaction log backup created after
-- the differential database backup.
RESTORE LOG MyAdvWorks
FROM MyAdvWorks_log1
WITH NORECOVERY;
GO
RESTORE LOG MyAdvWorks
FROM MyAdvWorks_log2
WITH RECOVERY;
GO

machan sequence ekak build karanne kohomada..??
mehema seen eka machan..full backup eka yanne ra 12 ta differencial eka etana idana man dipu script eken 12 idala differencial backup paya 4n 4ta wadinawa...etakota machan me dipu query eken e widiye ekak restore karaganna puluwanda

 

[climaxorg]

Use stackoverflaw

Oya stackoverflaw gana ahala nadda. Eeeya halo

 

[G-Street]

machan sequence ekak build karanne kohomada..??
mehema seen eka machan..full backup eka yanne ra 12 ta differencial eka etana idana man dipu script eken 12 idala differencial backup paya 4n 4ta wadinawa...etakota machan me dipu query eken e widiye ekak restore karaganna puluwanda

sequence eka kiyanne uba dana backup set eke sequece
1.full backup
2.diff bak1
3.diff bak2 .
4.diff back 3 etc
uba code(T-sql) eken restore karanwanan mehema karanna

Ubata apu latest full backup eka with norecovery dala restore karanna.
next hithamuko uba diffrentail backup 4 damma kiyala, full backup ekata pasee,first 3 diff backup set eka with norecovery dala restore karanna.
last diff eka with recovery dala restore karanna.

Ubata thiyana easy way eka thama.GUI eken restore karana eka .first select latest full backup
then select all diff backups in sequence 1,2,3,4 etc(create date eken ascending)
click ok
then select with recovery option.
next gui box eke uda thiyanwa generate script button.eka click karanna
gui eka close karanna
code eka query window eke athi
eka execute karanna