is it possible to just restore particular tables from a back up of a database

Hi,

I backed my sql server database on Fri at 3:15pm and then tried importing some tables individually from a different database and but that didnt work out too good, so is there a way i can just restore particular tables from the backup.

any help will be appreciated.

regards,

Karen

AFAIK, you need to restore the db first to retrieve any information from the files.|||I don't think it is possible to just restore one table. What I have done in the past is to restore the backed up database with a new name and then copy the table from the backup to the operational.|||

Restore database with different name and next copy data from tables you need to your destination

Thanks

|||

thanks a lot for your answers i just restored the database to it previous state

Regards,

Karen

sql

Is it possible to import users logins when u restore a DB?

Im abit puzzled here and im looking to see if there is any easy solution

Case:

Have Backed up an DP, then Restored it on another computer.

Then all users will be in the system (Not visible to users, but in sys info)

OK!

Then I set up all LOGINS...

After all this procedure is completed I use the sp_change_users_login Update_One function...

Question:

Cant I just import or other way use old logins/users

(I know this msg might sound weird, but hehe I hope someone knows what I mean..)

Thx!As far as I know there isn't since the logins are stored in the master database. Unless in your scenario you can backup the master database and restore it on the other computer after doing the same for your database.

This worked for me when upgrading from SQL 7 to SQL 2K.|||oh! :eek:

Many thanks, I will try that one :p|||You can use command line utility bcp to copy the master..syslogins table
out of server1 and then bcp it back in to server2. Make sure you use
-c option as this will allow you to edit the output since you will need to
remove any entries which already exist in server2 (eg. "sa") in order
to prevent it falling over with duplicate key errors.

Type bcp on command line to get full list of options.|||2Scre@.m
Sorry, but I think that guys were wrong.
Read this
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q298897
and other links from it.

Is it possible to import a backup

Had sql database on a dual boot machine... backed up the sql database ...
now put sql on the windows 2003 server... not sure how to import the databas
e to the new sql server... any suggestions or links would be appreciated."Vincent Keller" <anonymous@.discussions.microsoft.com> wrote in message
news:E69894D4-2385-4242-A34A-016B2AA94462@.microsoft.com...
> Had sql database on a dual boot machine... backed up the sql database
... now put sql on the windows 2003 server... not sure how to import the
database to the new sql server... any suggestions or links would be
appreciated.
>
RESTORE DATABASE dbname
FROM wherever
WITH MOVE logical_name TO 'C:\data\whatever.mdf'
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.647 / Virus Database: 414 - Release Date: 29/03/2004sql