how to take backup of the DB - 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

SQL Server 2008 Forums

SSIS and Import/Export (2008)

how to take backup of the DB

Author

Topic

vinu
Starting Member

34 Posts

Posted - 2010-12-15 : 03:11:20

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...

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-15 : 03:50:29

Why SSIS? Backups are typically done with maintenance plan or SQL script.

--
Gail Shaw
SQL Server MVP

vinu
Starting Member

34 Posts

Posted - 2010-12-15 : 04:26:05

Thanks for replying..
ok.. but how to do it..
i want to take backup and store it in another system..

vinu
Starting Member

34 Posts

Posted - 2010-12-15 : 04:47:18

i've two system..
in one system i've remotely login another system's database..
so in my object explorer i've two database connection.
sys1\sqlexpress and sys2\sqlexpress
now i want to take backup of sys2\sqlexpress and store ..

is it possible

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-15 : 05:59:42

Open a new query on that server, write the Backup Database command and run it.

Do you have any SQL experience? Are you just trying to take a backup, or is there something more complex happening here?

--
Gail Shaw
SQL Server MVP

vinu
Starting Member

34 Posts

Posted - 2010-12-15 : 06:10:48

ya.. i'm new to this..
wat i'm trying is i've connected to the remote server..
in my object explorer there are two connections
one is mine and another is servers..
i've tried.. in obj explorer->right click on DB-> task
and backup ..
but i want to save in my system.
in browse for folder it is showing server drives..
wat to do..

Kristen
Test

22859 Posts

Posted - 2010-12-15 : 06:14:47

Backup up the database on a drive on the remote server

Then transfer the file to your local system

Then restore the file you have locally

Yes, you COULD get the remote system to backup DIRECT to your local machine, but there are LOTS of issues to solve doing that, and much better you try a simple method first.

If you want to do this regularly I would STILL recommend that you backup to local disks and transfer the file, rather than trying to configure a backup directly to remove location. The utility ROBOCOPY can be used to copy (or MOVE if your prefer) the file to a remote location - it is tolerant of network outage, timeouts, all sorts of network problems that will be a complete nuisance for you if you try to backup direct to remote location.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources