Database

Hi..

I've one plm..

ie.. How to Backup and Restore Database in SQL server 2005.

Give me a way..

Thanx & Regards,

Muthupandi.P

refer this link, http://msdn2.microsoft.com/en-us/library/ms186865.aspx

Backup database dbname to disk='D:\Test\Dbname.bak' is the basic command ............where 'D:\Test\ is the path where you want the backup to be located..........you can put your desired path.....

For restoring the db,http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups

for creating backup jobs using maintenance plans in sql 2005 refer,

http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

hope this helps..............

Thanxx

Deepak

|||

I hope u have books online (help for sql server) installed on your machine. if not download it from

http://www.microsoft.com/downloads/details.aspx?FamilyID=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

Read Database Backup and restore in Books online. it has very detailed information with examples

Madhu