how to take backup of the DB

vinnu

15y8.2k

hi...
i want to take the backup of the DB..
in my system there are two DB employee and department
now using SSIS how can i take the backup of the employee DB..

i'm new to this SSIS..

i'm using sql server2008 enterprise edition.

please help me...

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

chinna venkat15y ago
if u want take a back up just follow this steps open ObjectExplorer Rtclick Databases select stop then go to database path where it is (take two files .mdb and log file)copy that and paste other place again u can start the sql server
sandeep kodepaka15y ago
Hi
Hit this link, it will help you
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7bd8cecf-3926-4a43-a9a3-fe48ebcfe993
Crish15y ago
Hi

I had same problem.You can use following code for backup data in sql server2008 enterprise edition.

You can use following code to solve the issue of to take backup of the DB.

Dim server

Dim backup

Set server = CreateObject("Microsoft.SQLServer.Management.SMO.Server")

Set backup = CreateObject("Microsoft.SQLServer.Management.SMO.Backup")

backup.Action = 0

backup.Database = "test_old"

backup.SqlBackup(server)
If you want to get more detail about backup than just go for this link.

http://social.msdn.microsoft.com/forums/en-US/sqlsmoanddmo/thread/7dde2d76-682e-46b7-847d-60fbfef249e9/