Unload and Load - 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 2005 Forums

Transact-SQL (2005)

Unload and Load

Author

Topic

asuni
Yak Posting Veteran

55 Posts

Posted - 2010-05-31 : 07:55:10

Hi All,

Can we Unload and Load a database using commands?
Not Backup and Restore.

thanks
Suni

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-05-31 : 08:17:21

What do you mean by load and unload? Take offline? Export data? Detach? Something else?

--
Gail Shaw
SQL Server MVP

asuni
Yak Posting Veteran

55 Posts

Posted - 2010-06-01 : 02:57:05

Hi Thank you.
Unload in the sense, I want the command which dumps some or all of a database to an external file.

To restore database information from an external file, i need LOAD command.

thanks
Suni

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-01 : 03:02:51

Why not backup and restore?

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources