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 for setting up SQL 2000!

I got sbs 2003 server with sql 2000, and using backup data function to move
the database to another 2k server w/sql2k, after I restore on the 2k server,
I from workstation try to login by using that data, but there is no account
appear on the screen.
What is wrong with it or I did something wrong in SQL setting?
Thanks!
Danny
The new server may not have the login accounts.
See these articles for more information:
Moving Server/Database/Logins
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/colu...rdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://support.microsoft.com/kb/274188 Troubleshooting Orphan Logins
http://www.support.microsoft.com/?id=240872 Resolve Permission
Issues -Database Is Moved Between SQL Servers
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Danny" <dannyf@.deny.com> wrote in message
news:%23%23TSFV49GHA.4464@.TK2MSFTNGP02.phx.gbl...
>I got sbs 2003 server with sql 2000, and using backup data function to move
>the database to another 2k server w/sql2k, after I restore on the 2k
>server, I from workstation try to login by using that data, but there is no
>account appear on the screen.
> What is wrong with it or I did something wrong in SQL setting?
> Thanks!
> Danny
>

Help for setting up SQL 2000!

I got sbs 2003 server with sql 2000, and using backup data function to move
the database to another 2k server w/sql2k, after I restore on the 2k server,
I from workstation try to login by using that data, but there is no account
appear on the screen.
What is wrong with it or I did something wrong in SQL setting'
Thanks!
DannyThe new server may not have the login accounts.
See these articles for more information:
Moving Server/Database/Logins
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/col...se
s.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://support.microsoft.com/kb/274188 Troubleshooting Orphan Logins
http://www.support.microsoft.com/?id=240872 Resolve Permission
Issues -Database Is Moved Between SQL Servers
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Danny" <dannyf@.deny.com> wrote in message
news:%23%23TSFV49GHA.4464@.TK2MSFTNGP02.phx.gbl...
>I got sbs 2003 server with sql 2000, and using backup data function to move
>the database to another 2k server w/sql2k, after I restore on the 2k
>server, I from workstation try to login by using that data, but there is no
>account appear on the screen.
> What is wrong with it or I did something wrong in SQL setting'
> Thanks!
> Danny
>

Help for maintenance plan

Hello to all
I make maintenance plan for backup of my SQL server 2000 database. I want to
make some changes in maintenance plan but i am not bale to see where can i
perform these changes? Need help
Regds
HenrikWhat changes are you trying to make?
If you open Enterprise Manager, go to Management, Maintenance Plans. Right
click the Maintenance Plan you created...go to properties. Then go to the
Complete Backup Tab...
If the option you are looking for is not there, then it's an option that can
only be changed during the creation of the plan.
You will have to create a new plan.
Donna Lambert
"Henrik" wrote:

> Hello to all
> I make maintenance plan for backup of my SQL server 2000 database. I want
to
> make some changes in maintenance plan but i am not bale to see where can i
> perform these changes? Need help
> --
> Regds
> Henrik
>

Help for maintenance plan

Hello to all
I make maintenance plan for backup of my SQL server 2000 database. I want to
make some changes in maintenance plan but i am not bale to see where can i
perform these changes? Need help
Regds
Henrik
What changes are you trying to make?
If you open Enterprise Manager, go to Management, Maintenance Plans. Right
click the Maintenance Plan you created...go to properties. Then go to the
Complete Backup Tab...
If the option you are looking for is not there, then it's an option that can
only be changed during the creation of the plan.
You will have to create a new plan.
Donna Lambert
"Henrik" wrote:

> Hello to all
> I make maintenance plan for backup of my SQL server 2000 database. I want to
> make some changes in maintenance plan but i am not bale to see where can i
> perform these changes? Need help
> --
> Regds
> Henrik
>

Help for maintenance plan

Hello to all
I make maintenance plan for backup of my SQL server 2000 database. I want to
make some changes in maintenance plan but i am not bale to see where can i
perform these changes? Need help
--
Regds
HenrikWhat changes are you trying to make?
If you open Enterprise Manager, go to Management, Maintenance Plans. Right
click the Maintenance Plan you created...go to properties. Then go to the
Complete Backup Tab...
If the option you are looking for is not there, then it's an option that can
only be changed during the creation of the plan.
You will have to create a new plan.
Donna Lambert
"Henrik" wrote:
> Hello to all
> I make maintenance plan for backup of my SQL server 2000 database. I want to
> make some changes in maintenance plan but i am not bale to see where can i
> perform these changes? Need help
> --
> Regds
> Henrik
>sql

Help backing up and restoring database

Hi,

I have been using the backup feature of SQL Express for some time and I thought it would be good to test a restore in case the worst happend. I moved my bak files to a usb memory stick and copied them to a machine and installed SQL Express so its empty no database's etc. So I right click the databae folder and choose restore from device and point to the db's but I get errors restoring them. What am I doing wrong? Is their any guides that give steps to backup and restore database's ? Any help would be great - I can of course provide more information need be.

Thanks,

Adam.

Hi,

Here is a good reference article for backup http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c11ppcsq.mspx

BTW you will have to post the error message to get a good answer, unless we cannot provide you the good suggesion.

Hemantgiri S. Goswami

|||

hi Adam,

2326ac wrote:

Hi,

I have been using the backup feature of SQL Express for some time and I thought it would be good to test a restore in case the worst happend. I moved my bak files to a usb memory stick and copied them to a machine and installed SQL Express so its empty no database's etc. So I right click the databae folder and choose restore from device and point to the db's but I get errors restoring them. What am I doing wrong? Is their any guides that give steps to backup and restore database's ? Any help would be great - I can of course provide more information need be.

Thanks,

Adam.

as Hemantgiri already pointed out, it's difficult to help torubleshooting without the actual exception message... but I can guess the Windows account running the SQLExpress intance has not been granted adeguated NTFS permissions on the backup source, the actual folder (path) containing the backup set..

regards

Help !

Hi,
What's the advantage of using sqlmaint over Backup database command?
With sqlmaint I read in site that it has lots of rights issue. Is it
correct?
Also with the Backup database command is it necessary to do DBCC checkdb
first ?
TIA,
GaryOn your 2nd point. No it's not necessary to run CheckDB
but it's good practice.
Without running the CHECKDB you could be backing up
corrupt data.
>--Original Message--
>Hi,
>What's the advantage of using sqlmaint over Backup
database command?
>With sqlmaint I read in site that it has lots of rights
issue. Is it
>correct?
>Also with the Backup database command is it necessary to
do DBCC checkdb
>first ?
>TIA,
>Gary
>
>.
>