Backup Database

Hi all,
I wanna Format my database server due to some reason...
so how i can Backup of SQL Server Databases...
i have around 25 Databases in Sql Server.. and i wanna take backup of all..
So how i can perform this task..
plz guide Step by step...
i m new in DataBase Backup ..... ;)
Thanx
SajjadGolden Rule number 1 - protect the data

If you have no Backup regime in place I suggest you create one - sharpish.
Then practice restoring the backups.

Create a New Maintanence plan under Management in EM (right click Maint Plans)

Create a new DB and backup then delete - re create the DB right click it and restore from Device - point device to .bak file.

Make sure you have all the logins recorded

GW|||You have 25 databases and NO BACKUPS?

Either get a DBA, or become a DBA, very fast. You can start by reading Books Online, which covers backups, log dumps, and everything else you need to know.|||thanx for reply,,
plz give some link of DBA books or give web address for this
thanx
Sajjad|||thanx for reply,,
plz give some link of DBA books or give web address for this
thanx
Sajjad
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx|||Books Online should have been installed with SQL Server by default. It should be in your Start menu along with SQL Server Enterprise Manager.

Backup

Hi

I had problem with my backup file. I'm taking backup on remote machine a full backup in append mode just because my database size is small.Due to some reason the backup was incompleted that was shown when i'm looking the file. Now when i' try to backup on same file it gives an error messages. Is it possible to remove the incomplete mark on file.Even if i try overite the file its not allowed. Tell me why its so and how to use the same file without moving it.Howdy

No - rename the old file & use a new file . If the old file is corrupted, you run the risk of continually using a corrupted backup - not a good thing.

Cheers,

SG.

Backup

Is there any way by which I can get the database which I had created
from the Registry? Due to a sudden power failure, the MSSQL7 directory
under the C:\ drive got deleted. I had the DB backup in the BACKUP
directory but since the entire MSSQL7 directory got deleted, I have
lost the backup.
I know there isn't any way to get back the DB but still asking this
question keeping my fingers crossed.
Thanks,
ArpanWhat do you mean by "from the registry" ?
Jens Suessmeyer.|||Afraid not.
Everything is held in the data files.
A bit late now but you really should copy the backups off the machine as
soon as they are complete otherwise you are stuck if you lose the disk.
Think about why you take backups.
"Arpan" wrote:

> Is there any way by which I can get the database which I had created
> from the Registry? Due to a sudden power failure, the MSSQL7 directory
> under the C:\ drive got deleted. I had the DB backup in the BACKUP
> directory but since the entire MSSQL7 directory got deleted, I have
> lost the backup.
> I know there isn't any way to get back the DB but still asking this
> question keeping my fingers crossed.
> Thanks,
> Arpan
>

Backup

Is there any way by which I can get the database which I had created
from the Registry? Due to a sudden power failure, the MSSQL7 directory
under the C:\ drive got deleted. I had the DB backup in the BACKUP
directory but since the entire MSSQL7 directory got deleted, I have
lost the backup.
I know there isn't any way to get back the DB but still asking this
question keeping my fingers crossed.
Thanks,
Arpan
What do you mean by "from the registry" ?
Jens Suessmeyer.
|||Afraid not.
Everything is held in the data files.
A bit late now but you really should copy the backups off the machine as
soon as they are complete otherwise you are stuck if you lose the disk.
Think about why you take backups.
"Arpan" wrote:

> Is there any way by which I can get the database which I had created
> from the Registry? Due to a sudden power failure, the MSSQL7 directory
> under the C:\ drive got deleted. I had the DB backup in the BACKUP
> directory but since the entire MSSQL7 directory got deleted, I have
> lost the backup.
> I know there isn't any way to get back the DB but still asking this
> question keeping my fingers crossed.
> Thanks,
> Arpan
>

Backup

Is there any way by which I can get the database which I had created
from the Registry? Due to a sudden power failure, the MSSQL7 directory
under the C:\ drive got deleted. I had the DB backup in the BACKUP
directory but since the entire MSSQL7 directory got deleted, I have
lost the backup.
I know there isn't any way to get back the DB but still asking this
question keeping my fingers crossed.
Thanks,
ArpanWhat do you mean by "from the registry" ?
Jens Suessmeyer.|||Afraid not.
Everything is held in the data files.
A bit late now but you really should copy the backups off the machine as
soon as they are complete otherwise you are stuck if you lose the disk.
Think about why you take backups.
"Arpan" wrote:
> Is there any way by which I can get the database which I had created
> from the Registry? Due to a sudden power failure, the MSSQL7 directory
> under the C:\ drive got deleted. I had the DB backup in the BACKUP
> directory but since the entire MSSQL7 directory got deleted, I have
> lost the backup.
> I know there isn't any way to get back the DB but still asking this
> question keeping my fingers crossed.
> Thanks,
> Arpan
>