how to create a .Bak file of my database

Question

Dear Friends,

Kindly show me the steps to create .bak file of a database file.

Thanks in advance.

---

EMCUBE

Answer 1

You need to issue a BACKUP command.

Look at the following articles:

http://msdn.microsoft.com/en-us/library/ms191304.aspx
http://msdn.microsoft.com/en-us/library/ms186865.aspx

HTH!

---

every day is a school day

Answer 2

Hi

Hear is just a simple example of the backup command

Use this for a full  backup

BACKUP DATABASE [Databasename] TO DISK "[Where on the disk to place the backup file Both the Path and the .bkp file]"

ex.
BACKUP DATABASE TestDB TO DISK "C:\Program Files\Microsoft SQL Server\MSSQL\Backup\Testdb.bak"

Use this for a log backup

BACKUP LOG [Databasename] TO DISK "[Where on the disk to place the backup file Both the Path and the .bkp file]"

ex.
BACKUP LOG TestDB TO DISK "C:\Program Files\Microsoft SQL Server\MSSQL\Backup\Testdb.bak"

Ragards

---

Jens Nilsson MCTS - SQL Server 2008 Imp. and Main.

Answer 3

Thanks.

---

EMCUBE