Backup using import/export

[maanton]

I run a forum using mssql server 2005 db on an ISP server and I want to back up the database.
I use the Management Studio and I have successfully taken backup of the tables using import/export.
Is there any way to backup using import/export the rest of the db (stored procedures, functions, views, triggers etc)?

 

[icemel]

Why not just take a full database backup and back up everything at once?

 

[Catadmin]

You can use the SQLCMD utility to run the Backup Database command. Check the Books Online for SQL 2k5 to get more details, but the command looks pretty much the same as the 2000 T-SQL command to me.

Also, the database maintenance toolbox has a Backup Database object. I haven't played around with 2k5 enough to know if you can use it ala 2000's EM right-click -> All Tasks -> Backup Database option or if the 2k5 toolbox actually requires you to set up a regular maintenance play for backing up your db, though.

Hope that helps.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.