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 files for MS SQL Management Studio Express?

Hi

Are there any specific Help files to download for SQL Server Management Studio Express. I thought I saw a link the other day, but I am not sure anymore... Or is it part of the Book online for SQL Server Management Express? I can't find reference to Studio in there...

Thanks

Gauguin

Hi,

Here are some links for MS Sql Management Studio Express Help.

-SQL Server 2005 Express Edition Documentation and Samples (December 2005)
-SQL Server 2005 Books Online (December 2005)

HTH,

Michael Castillones

|||

Thanks, the first link was the one I had been looking for.

W

sql

Help files for MS SQL Management Studio Express?

Hi

Are there any specific Help files to download for SQL Server Management Studio Express. I thought I saw a link the other day, but I am not sure anymore... Or is it part of the Book online for SQL Server Management Express? I can't find reference to Studio in there...

Thanks

Gauguin

Hi,

Here are some links for MS Sql Management Studio Express Help.

-SQL Server 2005 Express Edition Documentation and Samples (December 2005)
-SQL Server 2005 Books Online (December 2005)

HTH,

Michael Castillones

|||

Thanks, the first link was the one I had been looking for.

W

Help files for MS SQL Management Studio Express?

Hi

Are there any specific Help files to download for SQL Server Management Studio Express. I thought I saw a link the other day, but I am not sure anymore... Or is it part of the Book online for SQL Server Management Express? I can't find reference to Studio in there...

Thanks

Gauguin

Hi,

Here are some links for MS Sql Management Studio Express Help.

-SQL Server 2005 Express Edition Documentation and Samples (December 2005)
-SQL Server 2005 Books Online (December 2005)

HTH,

Michael Castillones

|||

Thanks, the first link was the one I had been looking for.

W

HELP - need a function like MID in access

I am looking for a function that behaves like the MID function in access. I need to return all values in a column that has a specific charater in a specific location within the string. Example: I need to return all rows that have the number 2 in the fourth position of column TEXT.

Quote:

Originally Posted by tingirl76

I am looking for a function that behaves like the MID function in access. I need to return all values in a column that has a specific charater in a specific location within the string. Example: I need to return all rows that have the number 2 in the fourth position of column TEXT.

Nevermind I got it...SUBSTRING(expression, startposition, length)....thank you anyway!!!