Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
m.esteghamat
Starting Member
47 Posts |
 Posted - 2012-06-05 : 06:30:12
|
| Hi2 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
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-05 : 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. |
 |
|
|
m.esteghamat
Starting Member
47 Posts |
Posted - 2012-06-05 : 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
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-05 : 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
47 Posts |
Posted - 2012-06-06 : 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 = 10GO" |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-06 : 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. |
|
|
|
|
|
|
|
|
restore diff backup - from filestream dbs