how to backup database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to backup database

Author

Topic

learning_grsql
Posting Yak Master

230 Posts

Posted - 2013-05-29 : 16:28:16

Hi,

To backup database, I right click on the database name and then select "Tasks" > "backup".

However I wonder if this is a correct procedure or shall I need to stop sql server before backup?

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2013-05-29 : 17:03:03

You do not need to stop sql server to perform a backup

Be One with the Optimizer
TG

prett
Posting Yak Master

212 Posts

Posted - 2013-05-30 : 23:36:39

Yes, this is the right step:

Tasks>>Back Up>>The Back Up Database.

You can choose any recovery model (FULL, BULK_LOGGED, or SIMPLE) & Backup type (Full, Differential, log).

NO need to stop SQL Server.

mohan123
Constraint Violating Yak Guru

252 Posts

Posted - 2013-05-31 : 01:02:26

Tasks>>Back Up>>

POPUP BOX will appear then give the destination where you want to store the backup then

go to options and to decrease the size of database (keep compress backup) --> Click OK

it will done

P.V.P.MOhan

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-05-31 : 11:47:29

You can also use the query window: BACKUP DATABASE myDB TO DISK = 'a_destination_path/a_file.bak'

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources