Backup Data from Sql Server 2008

Question

Good Morning....., I have a Small Dought In Sql Server 1.How To Backup Data from Sql Server 2008 With Data . Please Provide the Solution..... Thanks in Advance. VinayKumar .P

Shivanand Arur · Answer

I think you will have to run an sql script for taking a backup of your database... Check out some of these link... May be it will help you!!! http://ola.hallengren.com/sql-server-backup.html http://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/ http://msdn.microsoft.com/en-us/library/ms191304(v=sql.105).aspx http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-backup-database-command/ T hank you!!!

Shivanand Arur · Answer

Hello Vinay, you will have to first right Click on the Database in the Object Explorer and in the Tasks tab, select the "Backup" Option. So once you select "Backup" a new Window will open. So in the New Window, just check what is the Backup type... By default it will be "full". In the below section, you can select the destination, where you want to store the Backup file. Once you select that, you can click on OK Button and the Backup file will be stored with a .bak extension at you r desired location. Also Check out this link.. http://kb.eukhost.com/backup-and-restore-ms-sql-server-2008-database/ Hope this helps you out.... Please MARK this answer as accepted, if it helped!!!

vinay kumar · Answer

ThanQ Shivanand Arur For Providing Solutions

vinay kumar · Answer

yes u r correct i am talking about the Database stored on the Server?

Shivanand Arur · Answer

Sorry Vinay, But are u talking about the Database stored on the Server?

vinay kumar · Answer

Online Database

Shivanand Arur · Answer

I did not get you.. What do u mean by Online DB???

vinay kumar · Answer

ThanQ Shivanand Arur For Replying....... i have another doubht.. some times i observered in on line sql server in object Explorer (I connected Online Db with valid Credentials) the database names are not Exisited but when I typed any Query Reagrding that database they show result at that time with out showing database name in object explorer, how can we back up that database Please Provide Me Solution. Thanks in Advance Vinay Kumar.p

Backup Data from Sql Server 2008

Answers (8)