Backup Database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Backup Database

Author

Topic

cheapsonghy
Starting Member

2 Posts

Posted - 2009-11-27 : 01:41:31

Hi all member in this forum.

I have problem with T-SQL. I use T-SQL statement to backup database.

and I can backup already.

But the problem is that i want to zip my file backup automatically when it backup.

How can i do it?

Is it possible to do this by using T-SQL?

I hope all friends in this forum and forum god can help me.

thank u in advance.

vikky
Yak Posting Veteran

54 Posts

Posted - 2009-11-27 : 01:51:08

Hi,

to zip wile backup file available in sql 2008(new in sql 2008).
we have to get in sql 2005 we have to use pakages or Osql or SSIsql.

Thanks,
vikky.

cheapsonghy
Starting Member

2 Posts

Posted - 2009-12-01 : 04:49:08

thank vikky for ur replay.

but u know. I use to see someone use T-SQL in MSsql 2000 to backup database.

and the file backup is automatically zip.

I know how to backup by using T-SQL. but i don't know how to make it to file zip automatically when it backup.

this is my problem.

can anyone help me please?

Thank u in advance for all member that reply me.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources