September 2, 2008 at 1:07 pm
I would like to create a shortcut or desktop icon to allow a user to kick off a full database backup, for a SQL Server 2005 database. Does anyone have a suggestion? I've used SQL in other platforms but I'm new to Windows and don't know how to start a SQL Server process from a desktop icon. Do I need to build a batch process? Need some help. Thanks.
September 2, 2008 at 1:50 pm
You have a couple of options depending on your comfort level. You could do a batch process that calls sqlcmd and does the backup there. Or, you could do a quick and dirty .NET application using SMO to do the backup. I like the second one because it can give the user some feedback and doesn't start a DOS window.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 2, 2008 at 2:04 pm
I need to learn more about .Net apps. I like that option too. Do you have an example that you would share? Or, will you suggest an online resource for learning about creating .Net apps for this and other uses? I also need to create a front-end for some data entry and beleive .Net would be the way to go with that project too. Thanks much, Donna
September 2, 2008 at 2:19 pm
I don't have an example since I handle all the backups, etc..., but here are a couple of links, the second one is about backups:
http://www.yukonxml.com/articles/smo/
http://www.sqlmag.com/Article/ArticleID/45855/sql_server_45855.html
Depending on your background you may like C# or VB better. No matter what anyone says it really comes down to preference.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply