How to Create Database Backup Using SQL Server 2008 Express
Posted on 2011-03-12
I have been building my first ASP.NET web application using Visual Web Developer 2010 Express and SQL Server 2008 Express. All is working fine on my development machine.
I want to do some testing on my commercial host, and to load the database to the site they require it to be a backup (BAK) which then gets restored after I upload it.
I have lost about 5 hours trying to install SQL Server Management Studio Express, and still can't get it to install properly. Before I invest more time there, my first question is ...
... are there any other ways to create a database backup (BAK format) besides Management Studio?