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 12»»

Automated backup Expand / Collapse
Author
Message
Posted Monday, January 28, 2008 1:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 12, 2009 1:47 PM
Points: 24, Visits: 54
Was unsure where to place this post.
Windows Server 2003R2 w/ Sp2
MS SQL 2005

I currently use MS SQL 2005 to host my Citrix Datastore DB. I manually run a daily back up (Tasks>Backup).
How difficult would this be to automated? I saw a post from another user that this can be accomplished using a script? I have googled this without luck.

Any insight appreciated.

Thanks,
Kerry
Post #448542
Posted Monday, January 28, 2008 3:19 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 8:03 AM
Points: 120, Visits: 221
you can create a job to make a schedual backup of yourdatabase, if you r running a sql server 2005
Post #448616
Posted Monday, January 28, 2008 3:56 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 12, 2009 1:47 PM
Points: 24, Visits: 54
jiqubal (1/28/2008)
you can create a job to make a schedual backup of yourdatabase, if you r running a sql server 2005


Can you elaborate?

I already know how to manually run a backup. I just need to know the details on how to automate that process.
Post #448630
Posted Tuesday, January 29, 2008 1:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 22, 2009 1:36 AM
Points: 78, Visits: 137
Open 'Management' in Management Studio, select 'Maintenance Plans' and create a new maintenance plan using Maintenance Plan Wizard.
Post #448719
Posted Tuesday, January 29, 2008 1:26 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, May 10, 2012 1:39 PM
Points: 134, Visits: 90
Using Maintenance Plan Wizard, you can automate the backup maintenance.
Post #448723
Posted Wednesday, January 30, 2008 6:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 12, 2009 1:47 PM
Points: 24, Visits: 54
Thanks for the help! The Maintenance Plan (Wizard) worked great. Scheduled backups are running fine.

Kerry
Post #449344
Posted Wednesday, January 30, 2008 8:38 AM


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
Be sure that you are running transaction log backups as well if you are in full recovery model. you can add this to the maintenance plan.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #449454
Posted Wednesday, January 30, 2008 8:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 12, 2009 1:47 PM
Points: 24, Visits: 54
Steve Jones - Editor (1/30/2008)
Be sure that you are running transaction log backups as well if you are in full recovery model. you can add this to the maintenance plan.


Do I restore the Trans Log in the same manner I restored the DB's?

How do I restore the MASTER DB? From a command line I ran sqlservr.exe -f, but I don't know how to restore MASTER DB from command line?

Should I bve restoring items in a particular manner?

Appreciate the help!
Kerry
Post #449467
Posted Wednesday, January 30, 2008 9:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, October 17, 2014 7:46 PM
Points: 7,104, Visits: 15,425
There are special procedures to follow if you need to restore system databases.

You will want to read up on there from Books Online. Link is
http://msdn2.microsoft.com/en-us/library/ms190190.aspx


----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #449494
Posted Wednesday, January 30, 2008 9:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 12, 2009 1:47 PM
Points: 24, Visits: 54
Ok, update.

I performed the following:
1. Formatted the drive, installed OS, installed SQL 2005
2. Restored my specific DB
- NOTE: Did NOT restore the MASTER DB
3. Added user account under logins

All seems to be working.

Again, keep in mind this is a very small DB with on a single user. Am I missing something? Is there a method to automating the user account?

Kerry
Post #449510
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse