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
