Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MS SQL Server client Backup agent Expand / Collapse
Author
Message
Posted Thursday, January 22, 2009 7:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 3:43 AM
Points: 131, Visits: 558
Hello friendz,

I am a newbie, please help me. I want to install 'MS SQL Server Client Backup Agent'. I google it but i found unsatisfied results. Can you please tell me it is a software or what please give me solution for this.
Thanks in advance.
Regards,
m.i


________________________________________
M.I.

Learning is a path with no destination...

Post #641721
Posted Thursday, January 22, 2009 8:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 10,910, Visits: 12,547
Do you mean the agent for a backup product like BackupExec? Or, Do you want to be able to schedule SQL Server Native Backups?



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #641774
Posted Friday, January 23, 2009 2:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 3:43 AM
Points: 131, Visits: 558
yes yes, i want to schedule SQL Server Native Backups.


________________________________________
M.I.

Learning is a path with no destination...

Post #642335
Posted Friday, January 23, 2009 2:40 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:27 AM
Points: 4,432, Visits: 4,155
okiftequar (1/23/2009)
yes yes, i want to schedule SQL Server Native Backups.

There is no separate backup client if you want to use native SQL Server backup. It's part of SQL Server.
Just run a BACKUP DTAABASE statement or use Managemnet Studio.


Markus Bohse
Post #642344
Posted Friday, January 23, 2009 8:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 10,910, Visits: 12,547
Are you using SQL Server Express edition or another edition of SQL Server?

If you are using a version other than express you can use the backup the command (See BOL) and schedule it using SQL Server Agent.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #642482
Posted Friday, January 23, 2009 8:57 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, April 11, 2014 4:21 AM
Points: 97, Visits: 392
if you want a freely available seperate backup agent then try idera sqlsafe freeware

http://www.idera.com/Content/Show68.aspx?CartID=1011

Very useful compression agent. Usually compresses at around 20% of orginal db size depending on data held - and faster than native too.

HTH


My DBA Ramblings - SQL Server | Oracle | MySQL | MongoDB | Access
Post #642522
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse