Activity overview
Latest activity by arvind_rao
Well figured it out, was trying to restore the .sqb file with a Restore function ;-)
Ran it with "EXECUTE master..sqlbackup" & it works. Still had to backup the log before I tried to restore the db.
Chris thanks for your help. / comments
Well figured it out, was trying to restore the .sqb file with a Restore function ;-)
Ran it with "EXECUTE master..sqlbackup" & it works. Still had to backup the log before I tried to restore the db...
DBCC ran fine and was able to backup the log.. / comments
DBCC ran fine and was able to backup the log..
No change, same error....
-SQL "BACKUP LOG [MyDB2] TO DISK = N'C:\Temp\Log\DB2_FULL.log' " [SQLSTATE 01000] / comments
No change, same error....
-SQL "BACKUP LOG [MyDB2] TO DISK = N'C:\Temp\Log\DB2_FULL.log' " [SQLSTATE 01000]
hmm I did use LOGS as thats what the documentation said ;-) L. Back up transaction logs for multiple databases
This example creates transaction log backups for databases northwind and pubs in the default location.
SQLBackupC.exe -I {instance name} -SQL "BACKUP LOGS [northwind, pubs] TO DISK = '<AUTO>' "
EXECUTE master..sqlbackup '-SQL "BACKUP LOGS [northwind, pubs] TO DISK = ''<AUTO>'' " '
http://www.red-gate.com/supportcenter/C ... egs#o15223
will try with LOG now & see
Thanks for your help / comments
hmm I did use LOGS as thats what the documentation said ;-)L. Back up transaction logs for multiple databases
This example creates transaction log backups for databases northwind and pubs in the d...
@#$% didnt work [image]
-SQL "BACKUP LOGS [MyDB2] TO DISK = N'C:\Temp\Log\<AUTO>' " [SQLSTATE 01000]
-SQL "RESTORE DATABASE [MyDB2] FROM DISK = N'....sqb' WITH MOVE N'MyDB_Data' TO N'...MyDB2.mdf', MOVE N'MyDB_Log' TO N'..MyDB2.ldf', , NORECOVERY " [SQLSTATE 01000]
RESTORE LOG MyDB2 FROM DISK = '....sqb' WITH NORECOVERY [SQLSTATE 01000]
Msg 3241, Sev 16, State 1, Line 1 : The media family on device '...sqb' is incorrectly formed. SQL Server cannot process this media family. [SQLSTATE 42000]
Msg 3013, Sev 16, State 1, Line 1 : RESTORE LOG is terminating abnormally. [SQLSTATE 42000] / comments
@#$% didnt work
-SQL "BACKUP LOGS [MyDB2] TO DISK = N'C:\Temp\Log\<AUTO>' " [SQLSTATE 01000]
-SQL "RESTORE DATABASE [MyDB2] FROM DISK = N'....sqb' WITH MOVE N'MyDB_Data' TO N'...MyDB2.mdf', MO...
Chris, Thank for your tip.
I had tried replacing the db earlier, using EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [MyDB2] FROM DISK = N'... ' WITH REPLACE, MOVE N'MyDB_Data' TO N'...', MOVE N'MyDB_Log' TO N'...' "'
and although that ran fine, when I try to restore log files
RESTORE LOG MyDB2 FROM DISK = '...' WITH NORECOVERY
I get
The media family on device 'C:\....sqb' is incorrectly formed. SQL Server cannot process this media family.
I am not sure the issue is related so as I am trying to restore the log to a different DB (than original) OR cos the db is already closed/recovered as I used the REPLACE option
Any thoughts? / comments
Chris, Thank for your tip.
I had tried replacing the db earlier, usingEXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [MyDB2] FROM DISK = N'... ' WITH REPLACE, MOVE N'MyDB_Data' TO N'...'...
Error trying to Restore DB & Move files with NORECOVERY
Hi, I am trying make a copy our Production DB from a backup & running into issues described below
Basically I am trying to
1. Restore the MyDB as the MyDB2 with NORECOVERY & also move/replace the ...