PDA

View Full Version : Backup MS-SQL DB

Bahlool
08-03-03, 07:24 AM
Hi,

I'm new to Databases.

I wanted to know the various ways to back-up my Ms-SQL 2000 DB on the web server.

thanks!
Shane
08-04-03, 04:22 PM
Use SQL Server enterprise manager.

When you have a server setup in there, just navigate through the databases and right-click on the database you want to back-up. Once you right-click on the database name, select "All Tasks" and then select "Backup database". Just select a few options and you are set.

You can also use the Import/Export data wizard to back-up the data and structure to another server or another format (CSV, text-file, excel..etc)

Both of these tools (and the rest of the "Client Tools" can be installed VIA the free trial of SQL Server that you can download off of the MS site. These tools can be used forever because they never expire.
MadDog
08-06-03, 02:30 PM
I have MSSQL runing on my computer, so when i need to backup a database on my website i just export it to my comp on MSSQL, or i just export it as a MS Access file.
MadDog
08-06-03, 02:32 PM
O ya, i should mention that when you do an export all the default values in the table fields and any identities are lost, so if you import a database you would have to edit the database and add all the default values and identities again.

I wish Enterprise Manager would keep these values :(
Bahlool
08-09-03, 05:12 AM
Thank you guys! :D
jhiey
07-18-05, 05:21 AM
Use SQL Server enterprise manager.

When you have a server setup in there, just navigate through the databases and right-click on the database you want to back-up. Once you right-click on the database name, select "All Tasks" and then select "Backup database". Just select a few options and you are set.

You can also use the Import/Export data wizard to back-up the data and structure to another server or another format (CSV, text-file, excel..etc)

Both of these tools (and the rest of the "Client Tools" can be installed VIA the free trial of SQL Server that you can download off of the MS site. These tools can be used forever because they never expire.

Is it possible to automate this? i mean, my prob is i want to automatically backup only selected tables from my database once a week.. how will i do it?