back uping a table - 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

General SQL Server Forums

New to SQL Server Programming

back uping a table

Author

Topic

divyaram
Posting Yak Master

180 Posts

Posted - 2010-01-06 : 07:19:35

hi all,

I have a table named dbo.FIS_Degree in a DB by mistake a person has deleted a
column from the table now i want to take back up of the table...
i dont have an idea how to do the back up . can any one help from scratch for that

Regards,
Divya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-06 : 07:22:54

you cant restore a table alone. you need to restore entire db.
Alternative is to restore as a new copy and copy column values alone to your table.

divyaram
Posting Yak Master

180 Posts

Posted - 2010-01-06 : 07:24:22

now i dont knw wen the column has been delted so i dnt have the scripts for the deleted one

Regards,
Divya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-06 : 07:25:50

then how will you know which backup to be restored to get the data?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-01-06 : 08:11:48

First: what you want to do isn't a backup - it is a restore from a previous done backup.

So do you have backups of your database?
If yes - how old are they?

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

divyaram
Posting Yak Master

180 Posts

Posted - 2010-01-06 : 08:30:15

no previous backups are not there :(

Regards,
Divya

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-01-06 : 08:32:46

that's bad

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

divyaram
Posting Yak Master

180 Posts

Posted - 2010-01-06 : 08:36:58

:( what can do.... the table from which the column is deleted wont make a problem for me now... because it is having less no of data but... if it happens to table which contains more dat it will be problem ... so i have to take precaution for that.. webfred what shd i do ..whole DB should take backup in specific period ????

Regards,
Divya

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-01-06 : 08:46:50

Yes you should.
Look in google for backup strategies.
You will find something like this:
http://www.dbazine.com/sql/sql-articles/larsen12

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

divyaram
Posting Yak Master

180 Posts

Posted - 2010-01-06 : 08:56:11

can we schedule a job for back up in sql server 2008

Regards,
Divya

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-01-06 : 09:08:52