C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...




Forums » .NET » SQL Server »

BackUp of a Databases as Easily


Posted Date: 02 Nov 2009      Posted By: Muraleedharan.k      Member Level: Silver     Points: 1   Responses: 3



I have to take backup of all the databases in sql server 2005 as easily to a particular drive(C or D) with a single step.How to do that.Give a nice solution for that.



Responses
Author: sundaramoorthy.B    02 Nov 2009Member Level: SilverRating: 2 out of 52 out of 5     Points: 2

hi muraleedharan,

backup database <database name> to disk = 'c:\<DatabaseName>.bak'

this is useful for you.


Thanks & Regards,

Sundar


Author: :) Bob (:    02 Nov 2009Member Level: GoldRating: 2 out of 52 out of 5     Points: 2

Hai

Use Sql query


Author: atulpatel    03 Nov 2009Member Level: GoldRating: 2 out of 52 out of 5     Points: 2

Hi,

You will get different tips to Back Up database on following link
http://www.mssqltips.com/category.asp?catid=8


Thanks,
Atul


Post Reply
You must Sign In to post a response.
Next : Create Views with limited access
Previous : Executing
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages


dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use