Backup on SQL 2005

[Former Member]

Dear All,

We planned to take backup on MS SQL Server 2005, ECC 6.0 is running on Windows 2008 Server. Backup to be taken in fileserver.

Could anyone suggest, what are all the options are there.

Thanks

Guna

[Former Member]

Hi Guna,

As per my understanding, you want to take SQL backup and the target location is UNc path.

If this is the case, Its possible.

Select your database in Management studio --> right click --> select backup it will ask for the target file name but it wont show your UNC path there to select directly suggest, configure network path for your target location.You have to type your UNC path and you should not get any warning like "path could not found continue any way?".Since its UNc path, Backup time depends upon your network performance.

Thanks & Regards,

Nagendra.

[Former Member]

Hi Nagendra,

We have to schedule the backup in SQL, could you explain in details.

Thanks

Guna

[Former Member]

Hi Guna,

Check the below link.

You need to give your UNC path at destination

[Backup SQL 2005|http://www.exforsys.com/tutorials/sql-server-2005/sql-server-database-backup.html#art_cmts]

Thanks & Regards,

Nagendra.

[Former Member]

Hi Nagendra,

We scheduled backup thro' Maintenance Plan Wizard. There we specified the UNC path of the backup file.

Thanks

Guna

[Former Member]

Hi Guna,

I think you got solution for your issue.

Make this post as resolved.

Thanks & Regards,

Nagendra.

[Former Member]

Hi Guna,

What did you want in fact ??

how to make an SQL 2005 Backup !?

Pedro Rodrigues

[Former Member]

Hi Pedro,

SAP ECC 6.0 is running on Windows 2008 Server with MS SQL 2005, we are having backup space in file server. (UNC path).

Could you explain how many options are there to take backup.

Thanks in advance...

Guna