Help How Make Backup and Restore ?

Hi all. I'm newbie user of sqlserver 7.

I need make Backup from specific tables of my database and my application send this file by mail to other users that restore this information in yours Database.

How i can do it (i dont know the specifics commands to backup and Restore)

Other question

if I only backup the log file and restores this in other database
I'll have the same information in all users ?

Help me please

Thanks in AdvanceCheck BOL on the syntax. You can place your specific tables on filegroups and have your users restore those filegroups after initial full db restore.|||Check BOL on the syntax. You can place your specific tables on filegroups and have your users restore those filegroups after initial full db restore.

Excuse me, but i don't understand what is BOL. ?

How i said i'm newbie.|||Books
On
Line|||Originally posted by rdjabarov
Books
On
Line

Thanks, I will Try.|||I connect like database admin and

try to make differential backup using this command

1- Back up Database Cyber to XXX With Differential

2- Back up Log Cyber to XXX

The to test the back up

I run then this restore command

1- Restore database Cyber from XXX with norecovery and

2- Restore Log Cyber from XXX with recovery.

All is perfect

I close the connection

When I try to connect to Cyber database the server send me this message

Server Msg 927, Level 14 State 2

Database Cyber Cannot Be opened. It is in the middle of restore ?

Why the database cannot be opened ?

Thank In advance

Franklin|||Are you trying to open it from Enterprise Manager? I suspect that if you right-mouse click on Databases folder and select Refresh, - you won't get this error.|||I'm trying to open from query analizer, because my application must be do it (the backup - restore) using transaq - sql.

thanks
franklin

Originally posted by rdjabarov
Are you trying to open it from Enterprise Manager? I suspect that if you right-mouse click on Databases folder and select Refresh, - you won't get this error.sql

Help : Performance due to SQL Mail

Dear All,
I have a sql job that checking incoming email by using xp_findnextmsg,
read the incoming email then reply the sender with query result.
I schedule the job every minute.
My question is:
Does the job will make my sql server perfomance down?
Thanks
Robert Lie
Hi
The job itself, no. But test in your environment as to what affects your own
code you wrote causes on locking and blocking on your tables.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1121049371.109507.159220@.g14g2000cwa.googlegr oups.com...
> Dear All,
> I have a sql job that checking incoming email by using xp_findnextmsg,
> read the incoming email then reply the sender with query result.
> I schedule the job every minute.
> My question is:
> Does the job will make my sql server perfomance down?
> Thanks
> Robert Lie
>

Help : Performance due to SQL Mail

Dear All,
I have a sql job that checking incoming email by using xp_findnextmsg,
read the incoming email then reply the sender with query result.
I schedule the job every minute.
My question is:
Does the job will make my sql server perfomance down?
Thanks
Robert LieHi
The job itself, no. But test in your environment as to what affects your own
code you wrote causes on locking and blocking on your tables.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1121049371.109507.159220@.g14g2000cwa.googlegroups.com...
> Dear All,
> I have a sql job that checking incoming email by using xp_findnextmsg,
> read the incoming email then reply the sender with query result.
> I schedule the job every minute.
> My question is:
> Does the job will make my sql server perfomance down?
> Thanks
> Robert Lie
>

Help : Performance due to SQL Mail

Dear All,
I have a sql job that checking incoming email by using xp_findnextmsg,
read the incoming email then reply the sender with query result.
I schedule the job every minute.
My question is:
Does the job will make my sql server perfomance down?
Thanks
Robert LieHi
The job itself, no. But test in your environment as to what affects your own
code you wrote causes on locking and blocking on your tables.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1121049371.109507.159220@.g14g2000cwa.googlegroups.com...
> Dear All,
> I have a sql job that checking incoming email by using xp_findnextmsg,
> read the incoming email then reply the sender with query result.
> I schedule the job every minute.
> My question is:
> Does the job will make my sql server perfomance down?
> Thanks
> Robert Lie
>