thanks a lot for the tip that really worked for me, i want more infrmation & tips on the same, i am new to sql have just completed .NET at niit but it sucks they did not teach anything just took the fees & thats it.
I am glad to hear that! Though you can backup directly to the network but it is not considered good... as per the best practise for the reasons below:
• Network errors may occur during the backup process (for example, outages or data corruption).
• More resources are required than for a local backup. This can result in increased load on the SQL Server and increased duration for the backup.
• By depending on external network resources, backup performance becomes less predictable.
Ideally, you should backup locally and then use 'COPYTO' keywords to copy the backup file to network. You can read the help file and use the embedded help in the product itself to get more information. There are quite a few 'Notes & articles' as well as 'Knowledge base' articles which might be useful for you. Let us know if you have any specific questions and we would try our best to answer it.
Comments
Yes, you can backup/ restore directly over the network drive.
We also have a functionality where backups can be copied to the network drives after backing up locally.
Thanks,
Priya
Project Manager
Red Gate Software
Thanks for the info.
Can you back up direct to a share, e.g,. \\server\share or do you need to back up via a mapped drive letter?
Dave
You can backup directly to network \\server\share without mapping it to drive letter.
SQL Backup has 14 days of free trial. You might want to try it on your own.
Thanks,
Priya
Project Manager
Red Gate Software
thanks a lot for the tip that really worked for me, i want more infrmation & tips on the same, i am new to sql have just completed .NET at niit but it sucks they did not teach anything just took the fees & thats it.
Cheers!!
I am glad to hear that! Though you can backup directly to the network but it is not considered good... as per the best practise for the reasons below:
• Network errors may occur during the backup process (for example, outages or data corruption).
• More resources are required than for a local backup. This can result in increased load on the SQL Server and increased duration for the backup.
• By depending on external network resources, backup performance becomes less predictable.
Ideally, you should backup locally and then use 'COPYTO' keywords to copy the backup file to network. You can read the help file and use the embedded help in the product itself to get more information. There are quite a few 'Notes & articles' as well as 'Knowledge base' articles which might be useful for you. Let us know if you have any specific questions and we would try our best to answer it.
Regards,
Priya
Project Manager
Red Gate Software