<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Backups
»
Automated backup
11 posts, Page 1 of 2
1
2
»»
Automated backup
Rate Topic
Display Mode
Topic Options
Author
Message
kerry.corcoran
kerry.corcoran
Posted Monday, January 28, 2008 1:10 PM
Grasshopper
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
Shahzadi
Shahzadi
Posted Monday, January 28, 2008 3:19 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, November 05, 2012 4:51 AM
Points: 120,
Visits: 206
you can create a job to make a schedual backup of yourdatabase, if you r running a sql server 2005
Post #448616
kerry.corcoran
kerry.corcoran
Posted Monday, January 28, 2008 3:56 PM
Grasshopper
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
Mark Hemelrijk
Mark Hemelrijk
Posted Tuesday, January 29, 2008 1:17 AM
SSC 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
KarthikMalar
KarthikMalar
Posted Tuesday, January 29, 2008 1:26 AM
SSC-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
kerry.corcoran
kerry.corcoran
Posted Wednesday, January 30, 2008 6:47 AM
Grasshopper
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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Wednesday, January 30, 2008 8:38 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 9:24 AM
Points: 31,433,
Visits: 13,748
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
kerry.corcoran
kerry.corcoran
Posted Wednesday, January 30, 2008 8:56 AM
Grasshopper
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
Matt Miller (#4)
Matt Miller (#4)
Posted Wednesday, January 30, 2008 9:24 AM
SSCertifiable
Group: General Forum Members
Last Login: 2 days ago @ 7:57 PM
Points: 6,998,
Visits: 13,949
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
kerry.corcoran
kerry.corcoran
Posted Wednesday, January 30, 2008 9:35 AM
Grasshopper
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 »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
