Solved

red-gate.com

Posted on 2009-07-14
14
884 Views
Last Modified: 2012-06-22
Hi

Has anyone used red-gates sql_backup product to shrink and move .bak files over networks? If so does anyone know if it can be scheduled to shrink and move .bak up files at different times?

Cheers
0
Comment
Question by:ac_davis2002
  • 6
  • 4
  • 4
14 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 375 total points
Comment Utility
>> Has anyone used red-gates sql_backup product to shrink and move .bak files over networks? If so does anyone know if it can be scheduled to shrink and move .bak up files at different times?

Have used it as I informed you earlier. Its a Five step process.

1. Select your Server.
2. Select your Database and type of Backup
3. Configuration of Backup File settings and completion settings.
Here you have the option to configure backups to be moved to a Network Drive or a local drive and other related options
4. Configure compression, encryption and Optimization settings.

you have 3 levels of compression and the more compression you choose it take some more time.
Choose encryption if you require.

5. Review screen

Here you can save that as a template to be used at some later point of time and to verify your selections.

This template can be used for configuring scheduled jobs.

You can view the manual for more detailed info.
Hope you would be having a trial version now with you..

Hope this helps
0
 

Author Comment

by:ac_davis2002
Comment Utility
Hi rrjegan17

thanks for this, I do indeed have a trial version and I am backing up one of my local databases as we speak (type!)

I am still a bit concerned about how i being the .bak into my office network. For example I could create a vpn to connect to  server in mexico. I could then connect to the server using red-gates sql_backup and back up the db, or I could create a schedule to back up the db, my concern is, how, using this tool could I bring the .bak onto my server? is this where I use the copy back up to folder tick box, i have attached a screen shot to make my explaination clearer....
sqlback.doc
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 125 total points
Comment Utility
>>how, using this tool could I bring the .bak onto my server? <<
What does this mean?  Red-Gate does not create backups in the same format as Microsoft (The default extension is sqb).  Perhaps you can re-explain what you are trying to achieve.
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 375 total points
Comment Utility
>> using this tool could I bring the .bak onto my server?

As I mentioned earlier, Red-Gate uses their proprietary format (*.sqb) instead of SQL Server format(*.bak) for their compression and restore process. Hence you can't obtain a *.bak file.

In the snapshot attached, you can find Folder path above where backup file needs to be saved and there is an non-editable field saying that <auto>.sqb as the format.

And hence I mentioned that this is the only drawback with Red-Gate as they wont use *.bak files.

>> I do indeed have a trial version

Trial version will be fully functional for 15 days and hope you can try it out completely using this one.

>> What does this mean?  Red-Gate does not create backups in the same format as Microsoft (The default extension is sqb).  Perhaps you can re-explain what you are trying to achieve.

acperkins.. Actually ac_davis2002 was correct.
You need to use Red-Gate again to restore that backup file in sqb format.

And a tool from hyperbac ( competitor for Red gate) uses SQL Server proprietary format (*.bak) along with other formats like (*.zip), etc..

http://www.hyperbac.com/sqlserver.asp
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 125 total points
Comment Utility
>>And hence I mentioned that this is the only drawback with Red-Gate as they wont use *.bak files.<<
They do supply a utility to convert, but then you lose the compression and it may create multiple files.

>>Trial version will be fully functional for 15 days and hope you can try it out completely using this one.<<
Actually 14 days.  But who is counting?  :)

>>acperkins.. Actually ac_davis2002 was correct. <<
No doubt.  Since I did not understand him/her it was a moot point.
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 375 total points
Comment Utility
>> They do supply a utility to convert, but then you lose the compression and it may create multiple files.

As of now, they are not providing any utility for the compression.
If you want it in Native or SQL Server Format, then you have to use Hyperbac tool only.
No other go..

>> Actually 14 days.  But who is counting?  :)

It will appear once we open that Red Gate Backup application about how many trial days are left :)
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 125 total points
Comment Utility
>>As of now, they are not providing any utility for the compression.<<
I did not say that, so let's try that again:
You stated:
"And hence I mentioned that this is the only drawback with Red-Gate as they wont use *.bak files."
I agreed with you, but stated:
"They do supply a utility to convert, but then you lose the compression and it may create multiple files."
In other words they supply a utility to convert their sqb to MS bak

Got it?


>>It will appear once we open that Red Gate Backup application about how many trial days are left :)<<
Actually it is clearly stated on their download page.
https://www.red-gate.com/dynamic/downloads/downloadform.aspx?download=sqlbackuppro

Notice the following heading:
Download 14-day free trial
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 375 total points
Comment Utility
Thanks acperkins for pointing out..

I didn't got what you mentioned earlier and hope you referred to this

http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Backup&c=SQL_Backup\help\5.4\SBU_CommandCONVERT.htm

If we use the above command then it loses the compression as you earlier mentioned.

>> Download 14-day free trial

Yes.. Instead of 15 it was 14 day trial..
It ran in my mind that it was 15 and hence typed it earlier.
0
 

Author Comment

by:ac_davis2002
Comment Utility
thanks chaps.....i think :)
0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
>> hope you referred to this<<
Actually, no.  You are referring to the CONVERT parameter and not a utility, which would assume that you have a license to use SQL Backup.  

I was referring to the sqb2mtf.exe command line utility:
http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Backup&c=SQL_Backup/help/6.0/SBU_SQLBackupFileConverter.htm
This does not require a license and allows you to send a compressed and encrypted file in sqb format to a client that does not have SQL Backup and they can restore using MS SQL Server.
0
 

Author Comment

by:ac_davis2002
Comment Utility
thanks acperkins,

all i am really trying to do is find a quick way of bringing a .bak file from a server in South Africa that is not networked to us, any ideas? if you do have any ideas other than using a ftp site and you want me to raise a new question please let me know :)
0
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
>> all i am really trying to do is find a quick way of bringing a .bak file from a server in South Africa that is not networked to us,

What is the size of that file and about Internet speed in both locations
0
 

Author Comment

by:ac_davis2002
Comment Utility
hi rrjegan17

I believe it is standard band with and the .bak is 4G
0
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
Other than Red Gate Backup, you wont get efficient compression of your 4 GB data.
Try using WinRar with best compression to reduce the file size to as small as possible.

FTP would be the best approach to share your data across internet.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Select2 jquery help 9 40
Acronis True Image HD 5 26
SQL Inner Join Vs SubQueries 9 23
Report Builder 9 22
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Is your computer hacked? learn how to detect and delete malware in your PC
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now