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

backup scripts Expand / Collapse
Author
Message
Posted Thursday, November 19, 2009 5:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 02, 2011 12:25 PM
Points: 10, Visits: 72
hi everyone,

i need a script (stored proc ) to identify all user databases in a server and then apply full backup, differential backup and transactional backup to them ( with their specific schedules )

and it should automatically delete all the backups keeping 2 recent backups in all the 3 types(full, diff, tran)

thanks,
praveen
Post #822024
Posted Thursday, November 19, 2009 7:14 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 12:46 PM
Points: 1,413, Visits: 4,531
try SSIS

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #822044
Posted Thursday, November 19, 2009 8:30 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 9:52 AM
Points: 44, Visits: 235
Check out this article, it will get you going in the right direction. It's a stored procedure for making Full, Diff, and Trans backups. Variables to pass in are database name and backup type.


http://www.mydigitallife.info/2009/08/26/how-to-perform-scheduled-backups-for-sql-server-2005-express/comment-page-1/


Steve


SQL Managed
Post #822059
Posted Thursday, November 19, 2009 9:54 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:11 PM
Points: 32,810, Visits: 14,959
A maintenance plan can do this as well.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #822090
Posted Thursday, November 19, 2009 11:00 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 6:42 PM
Points: 20,473, Visits: 14,120
Though the maintenance plan and ssis options are perfectly sound, here is a list of some possible scripts.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #822108
Posted Monday, November 23, 2009 5:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:16 PM
Points: 1,151, Visits: 4,601
sql.pravin (11/19/2009)
hi everyone,

i need a script (stored proc ) to identify all user databases in a server and then apply full backup, differential backup and transactional backup to them ( with their specific schedules )

and it should automatically delete all the backups keeping 2 recent backups in all the 3 types(full, diff, tran)

thanks,
praveen


Hi Praveen,
Check the links

For Backup
http://www.mssqltips.com/tip.asp?tip=1599

For Cleanup
http://www.sqlservercentral.com/Forums/Topic801727-1557-1.aspx


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #823203
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse