MS SQL Server client Backup agent

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » MS SQL Server client Backup agent

MS SQL Server client Backup agent

Rate Topic

Display Mode

Topic Options

Author

Message

MSQLDBA

Posted Thursday, January 22, 2009 7:38 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 21, 2012 8:49 AM
Points: 129, Visits: 551

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

Jack Corbett

Posted Thursday, January 22, 2009 8:39 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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

MSQLDBA

Posted Friday, January 23, 2009 2:22 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 21, 2012 8:49 AM
Points: 129, Visits: 551

yes yes, i want to schedule SQL Server Native Backups.

________________________________________
M.I.

Learning is a path with no destination...

Post #642335

MarkusB

Posted Friday, January 23, 2009 2:40 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:03 AM
Points: 4,218, Visits: 3,874

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

Jack Corbett

Posted Friday, January 23, 2009 8:05 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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.

Post #642482

dbamohsin

Posted Friday, January 23, 2009 8:57 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, February 22, 2013 2:50 AM
Points: 97, Visits: 351

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 »

Permissions