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.
| Author |
Topic |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2008-09-30 : 00:36:00
|
| Hello,What is the best way to create a backup of an SQL 2005 database on my hosting server?A side question:I have an SQL database with 4 tables.On one of the tables I added one new column and deleted another.How can I download the data from the old database version I have on my server and place the data on the columns of the new table that still exist?Thanks,Miuel |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 00:52:18
|
| Restore the last backup of your db before this change was done.But you will lose all changes you did in your db from that time till current. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-30 : 03:08:52
|
| Is it a dedicated server or a share server ?Your hosting provider should have a backup plan for clients |
|
|
|
|
|
|
Backup database