Loading backed-up user database in SQL Server 2k

[Arijit]

Hi ,
I have a file presumably backup of a User database from a SQL
Server(2k) database. I want to load/restore that in a local SQL Server
to be able to see the table , views , etc present in the database.

How do I do that ?

Thanks,
Arijit

[(Pete Cresswell)]

Re: Loading backed-up user database in SQL Server 2k

[color=blue]
>How do I do that ?[/color]

There's probably a more elegant way, but this one works for me on a regular
basis:

1) Find out what the name of the DB was.

2) Create a DB with that name on your server.

3) Right-click the new DB, select "All Actions", and choose "Restore".

4) Create a "Device" in the restore dialog that points to the .bak file.

Once it's restored, you'll still have user/permission issues. I can't speak to
them because the DBs I routinely "restore" have users that I know about already.

For those, I just delete all users in the restored DB, create like-named users
on my server, and then add them to the restored DB.
--
PeteCresswell

[Anonymous]

Re: Loading backed-up user database in SQL Server 2k

Thanks Pete. I did solve this on your line.

One worrying aspect. Just after posting to this group I have started
getting loads of virus mails. I did have anonymous profile but forgot &
used my real address in "From". Now that the damage has been done , how
can spare myself of this mindless SPAM ?

Admin : How can I get rid of this ?

Thanks,
Arijit



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[(Pete Cresswell)]

Re: Loading backed-up user database in SQL Server 2k

RE/[color=blue]
>One worrying aspect. Just after posting to this group I have started
>getting loads of virus mails. I did have anonymous profile but forgot &
>used my real address in "From". Now that the damage has been done , how
>can spare myself of this mindless SPAM ?
>
>Admin : How can I get rid of this ?[/color]

You can't. The best you can do is manage it.

To that end, I use MailWasher from www.FireTrust.com.

My vanity domain name is getting over 1,000 spams per day - mostly from
dictionary attacks and bogus NG addresses that I foolishly included my domain's
name in.

Without MailWasher, email would be unusable to me.

With MailWasher, I predict it will become unusable sometime in 2004 just because
the sheer volume of spam takes so long to process that so much more spam
accumulates during the processing that it becomes an endless loop....
--
PeteCresswell

[Jerry Boone]

Re: Loading backed-up user database in SQL Server 2k

Um... you can make a stand, but it's actually easier to bite the bullet and
change your email address. Spam sucks and so does spam software...

--
Jerry Boone
Analytical Technologies, Inc.

http://www.antech.biz

"Anonymous" <anonymous@devd ex.com> wrote in message
news:3fb9a2c7$0 $199$75868355@n ews.frii.net...[color=blue]
> Thanks Pete. I did solve this on your line.
>
> One worrying aspect. Just after posting to this group I have started
> getting loads of virus mails. I did have anonymous profile but forgot &
> used my real address in "From". Now that the damage has been done , how
> can spare myself of this mindless SPAM ?
>
> Admin : How can I get rid of this ?
>
> Thanks,
> Arijit
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]