Comments
Sort by recent activity
Here's the batch file I am using to restore my test server. Perhaps you could do something similar: @echo on
del B:\Restore\*.* /s /q
c:\Robocopy\ROBOCOPY.EXE /JOB:c:\Robocopy\CPOPM2_RESTORE1.RCJ
c:\Robocopy\ROBOCOPY.EXE /JOB:c:\Robocopy\CPOPM2_RESTORE2.RCJ
c:\Robocopy\ROBOCOPY.EXE /JOB:c:\Robocopy\CPOPM2_RESTORE3.RCJ
ren B:\Restore\CentricityPM\*.sqb FULL_CentricityPM.sqb
ren B:\Restore\CPM_Production\*.sqb FULL_CPM_Production.sqb
ren B:\Restore\CPM_Reports\*.sqb FULL_CPM_Reports.sqb
SQL Backup command line interface can only work on local servers.
CD "C:\Program Files\Red Gate\SQL Backup\(LOCAL)"
SqlBackupC -SQL "RESTORE DATABASE [CentricityPM] FROM DISK = 'B:\Restore\CentricityPM\FULL_CentricityPM.sqb' WITH RECOVERY, MOVE 'CentricityPM_DB' TO 'D:\MSSQL\Data\CentricityPM.mdf', MOVE 'PatientVisit_Table' TO 'D:\MSSQL\Data\CentricityPM_1.NDF', MOVE 'PatientVisit_Text' TO 'D:\MSSQL\Data\CentricityPM_2.NDF', MOVE 'PatientVisit_Indexes' TO 'D:\MSSQL\Data\CentricityPM_3.NDF', MOVE 'CentricityPM_Log' TO 'E:\MSSQL\Data\CentricityPM.ldf', REPLACE" -E
SqlBackupC -SQL "RESTORE DATABASE [CPM_Production] FROM DISK = 'B:\Restore\CPM_Production\FULL_CPM_Production.sqb' WITH RECOVERY, MOVE 'CPM_Production_Data' TO 'D:\MSSQL\Data\CPM_Production.MDF', REPLACE" -E
SqlBackupC -SQL "RESTORE DATABASE [CPM_Reports] FROM DISK = 'B:\Restore\CPM_Reports\FULL_CPM_Reports.sqb' WITH RECOVERY, MOVE 'CPM_Reports_Data' TO 'D:\MSSQL\Data\CPM_Reports.MDF', REPLACE" -E
exit
You can get ROBOCOPY from http://www.microsoft.com/downloads/details.aspx?FamilyID=9D467A69-57FF-4AE7-96EE-B18C4790CFFD&displaylang=en
Cheers![/url] / comments
Here's the batch file I am using to restore my test server. Perhaps you could do something similar:@echo on
del B:\Restore\*.* /s /q
c:\Robocopy\ROBOCOPY.EXE /JOB:c:\Robocopy\CPOPM2_RESTORE1.RCJ
c:...
Peter and Vollker,
Until Redgate can impliment everything, have you considered just changing the Job steps via a SQl script? Jobs are just text records in msdb, and you should be able to easily manipulate these to add the commands you need for each job.
Just a thought.....
Rick in Phx / comments
Peter and Vollker,
Until Redgate can impliment everything, have you considered just changing the Job steps via a SQl script? Jobs are just text records in msdb, and you should be able to easily man...
SUre.I'll try it and let you know. / comments
SUre.I'll try it and let you know.
Peter, did you get the dumps? / comments
Peter, did you get the dumps?
We restarted the whole server Saturday night. That would include the SQLBackup agent.
We are still getting the 5240 errors, but not every time . I ran the SQl directly and it worked, no errors. But since it doesn't fail all the time, not sure that is significant.
Can I email you the two dumps I made? I have a dump showing the failing jobs and their frequency, plus a second dump of the acutal error messages. / comments
We restarted the whole server Saturday night. That would include the SQLBackup agent.
We are still getting the 5240 errors, but not every time . I ran the SQl directly and it worked, no errors. But...
Thanks, that is helpful.
But I need to cross-reference which error code will be thrown for the different warning codes, so we can handle different error codes as they occur, and also be able to track them backwards from their source.
Once again as an example:
Warning Code (Throws Error code)
175 775
I don't need anything elaborate, just an e-mail with code cross-reference would suffice.
If I need to contact your Dev group directly, that's fine. Just pelase let me know what I need to do to get the info. / comments
Thanks, that is helpful.
But I need to cross-reference which error code will be thrown for the different warning codes, so we can handle different error codes as they occur, and also be able to tra...
I follow you on this.
Peter, can you supply us with a cross reference of warning codes to raise error codes, so that I can monitor these via SQL?
Example :
Warning Raise Error
175 775
or if you can point me at the correct documentation which gives this information.
Cheers!
Rick / comments
I follow you on this.
Peter, can you supply us with a cross reference of warning codes to raise error codes, so that I can monitor these via SQL?
Example :
Warning ...
THanks! / comments
THanks!
I'm building some search HTML to be injected into the HTML pages, and as soon as I get done with it here in a few days, I'll share it with the forum.
That should help with big db's..... / comments
I'm building some search HTML to be injected into the HTML pages, and as soon as I get done with it here in a few days, I'll share it with the forum.
That should help with big db's.....
Yes. Works fine, Peter...... results are correct. / comments
Yes. Works fine, Peter...... results are correct.