backup and recovery - 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

SQL Server Administration (2005)

backup and recovery

Author

Topic

shajee
Starting Member

2 Posts

Posted - 2008-05-17 : 04:52:02

Hi,
I am new to sql server2005.
How to take a backup,restore&recovery operation in
sql server 2005.
Question No 1:
If i drop my "customer" table how can i get it back?
In oracle we will get back the table with the help of
incomplete recovery.

Question No 2:
How to connect as a user?
How to give the grant privilege to the particular user?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-17 : 10:26:45

Please check all these in Books online. You will get all answer

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-17 : 17:23:05

To recover deleted table, you need restore db from good backup then copy table over. Or with third party tools.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources