January 28, 2008 at 1:10 pm
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
January 28, 2008 at 3:19 pm
you can create a job to make a schedual backup of yourdatabase, if you r running a sql server 2005
January 28, 2008 at 3:56 pm
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.
January 29, 2008 at 1:17 am
Open 'Management' in Management Studio, select 'Maintenance Plans' and create a new maintenance plan using Maintenance Plan Wizard.
January 29, 2008 at 1:26 am
Using Maintenance Plan Wizard, you can automate the backup maintenance.
January 30, 2008 at 6:47 am
Thanks for the help! The Maintenance Plan (Wizard) worked great. Scheduled backups are running fine.
Kerry
January 30, 2008 at 8:38 am
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.
January 30, 2008 at 8:56 am
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
January 30, 2008 at 9:24 am
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?
January 30, 2008 at 9:35 am
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
January 31, 2008 at 12:58 pm
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 schedule the Tranaction Log backup to run at the same time as the DB backup?
When restoring do I simply restore after I have restored the DB?
Thanks,
Kerry
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply