Red Gate forums :: View topic - SQL Backup & SQL Server 2012
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

SQL Backup & SQL Server 2012

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mdgraves



Joined: 21 Sep 2007
Posts: 42

PostPosted: Wed Mar 14, 2012 1:18 pm    Post subject: SQL Backup & SQL Server 2012 Reply with quote

SQL 2012 RTM is available for download now, and licensing starting on 4/1/2012 (US). What are the plans for SQL Backup support of SQL 2012 platform within next 3 weeks?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 890
Location: Red Gate Software

PostPosted: Fri Mar 16, 2012 6:13 pm    Post subject: Reply with quote

Hi

Thank you for your post into the forum.

The current version of SQL Backup, V6.5.1.9 with the V6.5.2.18 patch, will allow SQL backup v6.5 to operate with SQL Server 2012.

V6.5.1.9 can be downloaded using this LINK

The V6.5.2.18 patch can be obtained using this LINK

You need to be aware of couple of things that may catch you out.

The first is that you will not be able to deploy the SQL Backup Server Side Components directly from the GUI. Once you have installed the V6.5.1.9 GUI, locate the Server components installer file SQBServerSetup.exe copy it to the SQL Server 20102 machine , if not already on there and run the exe file.

Second, you will need to have a Windows account available for the SQL Backup Agent service to use prior to running SQBServersetup.exe. SQL Server 2012 will not allow the user account specified for the SQL Backup Agent service to be a local system or NT Authority\System account. Also the Windows account you specify must be a member of the sysadmin fixed server role.

SQL Backup V7 is currently in development. SQL Backup V7 is expected to be released mid to late April 2012. Sorry, I do not have any information as to an exact release date. You can download EAP versions of SQL Backup V7 from this forum post if you wish to try out SQL Backup V7 and see the new features prior to it's official release.

I hope the above answers your question.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Fri Mar 16, 2012 10:32 pm    Post subject: Reply with quote

Eddie,

We are running 6.5.2.9.

What fix were added to produce 6.5.2.18?

Thanks

Chris
_________________
English DBA living in CANADA
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 890
Location: Red Gate Software

PostPosted: Wed Mar 21, 2012 8:30 pm    Post subject: Reply with quote

Hi Chris

SQL Backup V6.5.1.9 will support SQL Server 2012 on its own.

The patch V6.5.2.18 fixes a problem when using the wildcard character in your backup script with SQL 2008 R2 and SQL Server 2012 database snapshots.

SQL Backup attempts to backup the snapshots and obviously fails. The V6.5.2.18 patch forces SQL Backup to ignore the snapshots when a backup job runs using the wildcard character.

I included it in my reply, in case that user made use of the database snapshot feature of SQL 2008 R2 and SQL Server 2012.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
mdgraves



Joined: 21 Sep 2007
Posts: 42

PostPosted: Wed Mar 21, 2012 8:53 pm    Post subject: Reply with quote

Thanks Eddie. I'll download the V6.5.2.18 very soon and start testing it against my current SQL (2000, 2005, 2008R2) in my DEV and my new SQL (2012) in sandbox.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 890
Location: Red Gate Software

PostPosted: Wed Mar 21, 2012 9:29 pm    Post subject: Reply with quote

Hi

Thank you for your reply. Remember, you will need to download the official latest version V6.5.1.9 and install this first before applying the V6.5.2.18 patch.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
mdgraves



Joined: 21 Sep 2007
Posts: 42

PostPosted: Fri Mar 23, 2012 9:03 pm    Post subject: Reply with quote

Eddie.
There are two files within SQB_6_5_2_18.zip
I am unable to find doco on patch. Do I copy / replace files on my machine with these two?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 890
Location: Red Gate Software

PostPosted: Mon Mar 26, 2012 3:25 pm    Post subject: Reply with quote

Hi

To apply patch, please follow the steps below:

1. Stop the SQL Backup Agent Service.
2. In the Server Components Install folder, which by default is C:\Program Files (x86)\Red Gate\SQL Backup 6\(local) or <SQL Instance Name>, locate the V6.5.1.9 versions of SQBCoreService.exe and SQLBackupC.exe.
3. Rename the V6.5.1.9 versions of SQBCoreService.exe and SQLBackupC.exe (for example) to OLDSQBCoreService.exe and OLDSQLBackupC.exe .
4. Copy in the V6.5.2.18 SQBCoreService.exe and SQLBackupC.exe files extracted from the patch zip file.
5. Restart the SQL Backup Agent service.
6. Perform your backup and restore tasks to ensure that all is OK.


I hope the above answers your quetion regarding the patch. The existing files are renamed in case you need to go back to the official version.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
mdgraves



Joined: 21 Sep 2007
Posts: 42

PostPosted: Mon Mar 26, 2012 4:14 pm    Post subject: Reply with quote

thanks Eddie.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group