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 2, 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: Tuesday, October 14, 2014 12:10 PM
Points: 1,414, Visits: 4,541
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: 2 days ago @ 3:49 PM
Points: 31,161, Visits: 15,607
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:06 PM
Points: 17,805, Visits: 15,716
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
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: Monday, October 13, 2014 7:16 AM
Points: 1,159, Visits: 4,656
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