Database backup & Restore.

[Former Member]

Hi Experts,

I m new in SAP .we r using SQL Server 2005. can u share with me step by step

1) details to take database backup .

2) how we can again restore that .

3) can we save this to disk or we require other device?

Thanks in advance

Regards,

Vinayak

[Former Member]

Hi,

Please refer to the [link|http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups].

You can save the backup database on the same disk, you also schedule your database for automatic backup, you can choose daily, weekly & monthly and time desired.

Regards,

Clint

[Former Member]

Hi,

With all respect

I think you should take a few SAP courses first to understand the underlying architecture..

Mark