SQL server Back up

[eldhosejacob]

how can i take sql server back up

[vijil]

hai friend,
U can take the back up by executing the following Query.


backup database db_name to disk='path'

eg:
backup database vijil to disk='c:\db_bac kup'

[rdfanta]

You can also use Database Maintenance Plan to create a backup and check Integrity and optimize and then shedule these to be reoccuring.

[michelle]

You can also go to the directory:

C:\Program Files\Microsoft SQL Server\MSSQL\Da ta\

If you want to backup for example the database Northwnd, you will find for this file the extentions: .ldf and .mdf

You can backup these two files and if you need them again, place the two files back to this directory.

This is the most simply way to create a backup and it is allways safe.

Michelle.

[rdfanta]

The only problem with this method is that you have to bring down SQL Server to do it.

You can also go to the directory:

C:\Program Files\Microsoft SQL Server\MSSQL\Da ta\

If you want to backup for example the database Northwnd, you will find for this file the extentions: .ldf and .mdf

You can backup these two files and if you need them again, place the two files back to this directory.

This is the most simply way to create a backup and it is allways safe.

Michelle.