Activity overview
Latest activity by rick.sheeley
Perforce setup: Item missing from RedGate Documentation
In order for SSC to work with Perforce, you must add in the Perforce environmental variable $P4Port.
THis can be added in under windows start/Computer/(right-click)/Properties/Advanced Properties/E...
Deployment Wizard - final output to temp folder is deleted
OK, a minor issue here but a painful for me today. :oops:
Not a bug per say, but something you should probably change...
In the Deployment Wizard step of the SQLCompare, the sync scripts are beaut...
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.....
Database Diagrams
Is there any way to pull the database diagrams across to the knowledge repository as well?
Yes. Works fine, Peter...... results are correct. / comments
Yes. Works fine, Peter...... results are correct.
SQL Error 913 on SQL Backup of database(s) with new db's
Two databases, EZCAP_LHCHPLSR and EZCAP_LHNCHPLS were added to the database in question on 07/20/2010.
We are receiving the following error on nightly backups since 07/21:
-SQL "BACKUP DATABASES EX...
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...
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:...
SqlBackupC never finishes
Hey guys,
So I'm using the SqlBackupC cmd line tool for the first time to create a backup/restore file for our test server.
I'll be trying again this weekend, but the first two tests have failed mi...