| Author |
 Topic  |
|
|
m.esteghamat
Starting Member
18 Posts |
 Posted - 06/05/2012 : 06:30:12
|
Hi
2 question please:
first :
1- I restore full backup from a filestreamdb in norecovery mode.
2- then restore diff backup. but get error.
I do this for 3 time but get error.
But I canRestore Log backup without eny error.
(I do this for non filestream db and successfully)
second :
log backup refere to last full backup or last diff backup.
thank you .
bye
|
|
|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
Posted - 06/05/2012 : 06:43:02
|
What is the error?
The first log restored needs to be the first taken after the last diff or full restored.
If you have problems with the diff you can restore all the logs after the full and yoou don't need the diff - it just makes it easier and faster.
The nice thing about log files is that you are ok if you are missing a full or diff as they are independent - yoou just need all the logs soince the last backup you restore.
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
Edited by - nigelrivett on 06/05/2012 06:45:01 |
 |
|
|
m.esteghamat
Starting Member
18 Posts |
Posted - 06/05/2012 : 07:12:32
|
Hi
Thank You. This is error text :
"restore failed for server ... "
"system.data.sqlclient.sqlerror :the file "filesdb" can not be moved by the restore Operation"
--------------------------------------------------------
-- Restore diff comm :
RESTORE DATABASE [FileSDB2] FROM DISK = N'G:\0DBBackup\Filesdb_backup-Diff'
WITH FILE = 1,
MOVE N'FileSDB' TO N'g:\0DBBackup\FS\FileSDB.mdf',
MOVE N'FileSDB_log' TO N'g:\0DBBackup\FS\FileSDB_log.ldf',
MOVE N'FileStream_LN' TO N'g:\FileStream_LN_2', NOUNLOAD, STATS = 10
|
|
|
|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
Posted - 06/05/2012 : 09:37:29
|
Have you tried it without the move statements?
The full restore can move files but the diff can't move them again - it updates the files in place.
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
|
|
|
m.esteghamat
Starting Member
18 Posts |
Posted - 06/06/2012 : 03:01:35
|
Hi nig.
Thank you for your reply.
I try restore without move and successfull restored.
I found an important note :
After First Full Restore , I Change Mdf,ldf and filestream paths. then sql uses move statement and result was error.
I Found after first restore, shouldn't change pathes . beacuse full backup restore, remember these.
"RESTORE DATABASE [FileStreamDB2] FROM
DISK = N'G:\DBA-Docs\Filestream\BackupTest\DiffBack-1-after-4data'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10
GO
"
|
Edited by - m.esteghamat on 06/06/2012 03:04:32 |
|
|
|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
Posted - 06/06/2012 : 04:23:24
|
Think that's what I said :).
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
|
|
| |
Topic |
|
restore diff backup - from filestream dbs
