d) If you want to compress backup go to options and select "set backup compression" to "compress backup".
Regards,
B.ShivaKarthik
Project Manager
Mumbai , India
-------------------------------------------------
Don't Forget to Mark as Answer for the post that helped you.
-------------------------------------------------
reefking
Member
10 Points
13 Posts
How do I backup my local database to a .BAK file (Visual Studio 2010)
Apr 04, 2012 09:29 AM|LINK
Hi,
Can anyone tell me how to do this please?
Regards
pkay
Member
31 Points
26 Posts
Re: How do I backup my local database to a .BAK file (Visual Studio 2010)
Apr 04, 2012 09:37 AM|LINK
Please open your SQL Management Studio where the database is located, try following steps.
1) Right Click on your Database
2) Click on Tasks and choose the Back Up
3) After that popup window will appear, Please find and click on add button to make a new backup file or use existing file.
4) Select drive for back file destination.
5) Then, Click ok.
DarrellNorto...
All-Star
86555 Points
9624 Posts
Moderator
MVP
Re: How do I backup my local database to a .BAK file (Visual Studio 2010)
Apr 04, 2012 09:38 AM|LINK
Download SQL Server Management Studio Express from here (http://www.microsoft.com/download/en/details.aspx?id=22985) and install.
Right-click a database, and choose backup.
Darrell Norton's Blog
Please click "Mark as Answer" if this helped you.
Ruchira
All-Star
42888 Points
7020 Posts
MVP
Re: How do I backup my local database to a .BAK file (Visual Studio 2010)
Apr 04, 2012 10:51 AM|LINK
Hello,
Check my blog post about this, with screenshots
http://ruchirac.blogspot.com/2009/11/how-to-get-database-backup-from-sql.html
My Tech blog | My YouTube ChannelPlease 'Mark as Answer' if this post helps you.ramiramilu
All-Star
95285 Points
14072 Posts
Re: How do I backup my local database to a .BAK file (Visual Studio 2010)
Apr 04, 2012 11:14 AM|LINK
other option, backup a database using powershell - http://www.intstrings.com/ramivemula/articles/backup-a-database-using-powershell/
Thanks,
JumpStart
TUFAN01MAN
Participant
1208 Points
301 Posts
Re: How do I backup my local database to a .BAK file (Visual Studio 2010)
Apr 04, 2012 11:45 AM|LINK
write command to your sqlcommand object and execute it
as fallows:
sqlcommand.commandtext="backup database YourDatabaseName to disk='c:\someFolder\YourDatabaseName.bak'" ;
sqlcommand.Executenonquery();
Hope it helps
reefking
Member
10 Points
13 Posts
Re: How do I backup my local database to a .BAK file (Visual Studio 2010)
Apr 04, 2012 11:52 AM|LINK
Thanks for your replies, I have downloaded the SQL Server Management Studio but cannot connect to my database, see screenshots.
http://i.imgur.com/1EzlE.jpg
http://i.imgur.com/8acCI.jpg
Im sure its something Im doing wrong..please help
reefking
Member
10 Points
13 Posts
Re: How do I backup my local database to a .BAK file (Visual Studio 2010)
Apr 05, 2012 07:46 AM|LINK
anyone?
ShivaKarthik
Participant
1675 Points
277 Posts
Re: How do I backup my local database to a .BAK file (Visual Studio 2010)
May 26, 2012 09:33 AM|LINK
a) Go to Database
b) Right Click on the database
c) Go to Tasks and select backup
d) If you want to compress backup go to options and select "set backup compression" to "compress backup".
B.ShivaKarthik
Project Manager
Mumbai , India
-------------------------------------------------
Don't Forget to Mark as Answer for the post that helped you.
-------------------------------------------------
pkay
Member
31 Points
26 Posts
Re: How do I backup my local database to a .BAK file (Visual Studio 2010)
Nov 23, 2012 05:57 AM|LINK
Hi Reefking,
Please check your server is running in service. Seems it is not running your SQL Server service or start yet.
If you want to know more details please visit this blog to resolve your issue.
http://sqlexe.wordpress.com/2012/11/23/sql-server-2008-r2-cannot-connect-to-server/
I just share this link for someone who is facing the same problem as you. Thanks.