How can I backup my sql server 2008 database on a remote server??
-
First Question. Do you automate your Backups to Happen at a Specific Time ? The Next thing you need to do is to text if you can place any File in the Share. Just Copy any File and paste it in your Share. if you have no Permission Problems then its Cool. Create a New Project create a cmd Project and Look at this Articles to Create a cmd application to Copy Files http://msdn.microsoft.com/en-us/library/cc148994.aspx[^] http://msdn.microsoft.com/en-us/library/system.io.file.copy%28VS.71%29.aspx[^] http://www.dreamincode.net/code/snippet1807.htm[^] http://www.computerhope.com/issues/ch000766.htm[^] When you are Done , Create a Batch File and Tell it Execute this File, to Create a Batch File and Run the Batch File on the time you know your Backups will be Done. I was gonna say you must use Jobs in SQL, am not Sure if you know them .
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
First Question. Do you automate your Backups to Happen at a Specific Time ? The Next thing you need to do is to text if you can place any File in the Share. Just Copy any File and paste it in your Share. if you have no Permission Problems then its Cool. Create a New Project create a cmd Project and Look at this Articles to Create a cmd application to Copy Files http://msdn.microsoft.com/en-us/library/cc148994.aspx[^] http://msdn.microsoft.com/en-us/library/system.io.file.copy%28VS.71%29.aspx[^] http://www.dreamincode.net/code/snippet1807.htm[^] http://www.computerhope.com/issues/ch000766.htm[^] When you are Done , Create a Batch File and Tell it Execute this File, to Create a Batch File and Run the Batch File on the time you know your Backups will be Done. I was gonna say you must use Jobs in SQL, am not Sure if you know them .
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
thanks a lot for your help, I'll take a look at them. Just one more question regarding sql server 2008. If I want to access a sql server 2008 database remotely from a computer that resides on a different network, should I use SQL server management studio 2008 or can I just use sql server SQL management studio 2005? I've been having a hard time connecting to the database remotely. I enabled remote connections and I added some rules to the firewall to open sql server ports but to no avail. I've done everything that could allow remote connection but failed to connect to it and when I telnet the server with its port number, the connections fails too. Is it possible that maybe the network that the server belongs is blocking remote connections?? Any opinions are welcome? Thanks in advance for all ur help:)
-
thanks a lot for your help, I'll take a look at them. Just one more question regarding sql server 2008. If I want to access a sql server 2008 database remotely from a computer that resides on a different network, should I use SQL server management studio 2008 or can I just use sql server SQL management studio 2005? I've been having a hard time connecting to the database remotely. I enabled remote connections and I added some rules to the firewall to open sql server ports but to no avail. I've done everything that could allow remote connection but failed to connect to it and when I telnet the server with its port number, the connections fails too. Is it possible that maybe the network that the server belongs is blocking remote connections?? Any opinions are welcome? Thanks in advance for all ur help:)
Well most of the Time i access SQL Servers within the same Network, or i remote Desktop. I suggest you look at you Antivirus. Turn it off and see if you can connect, if you can then consider add an Exeption for that Connection in your AV. Again the Errors you get when trying to connect to a Remote SQl Server might lead to a Solution. am not sure what Type of Errors you are Getting.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Well most of the Time i access SQL Servers within the same Network, or i remote Desktop. I suggest you look at you Antivirus. Turn it off and see if you can connect, if you can then consider add an Exeption for that Connection in your AV. Again the Errors you get when trying to connect to a Remote SQl Server might lead to a Solution. am not sure what Type of Errors you are Getting.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
Here's the error I get An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (.Net SqlClient Data Provider) I'll check the antivirus. Thanks a lot.
-
Here's the error I get An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (.Net SqlClient Data Provider) I'll check the antivirus. Thanks a lot.
-
-
yes, I know, I've searched these pages but still no access. I will try the antivirus thing and see if I can access it. Also I think it's the network that has a problem. Thanks a lot for all ur help.
You are Welcome
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Unfortunately the server doesn't allow ftp for security so I can't backup the database and then send it through ftp to the other server. So is there anyway I can do this from sql server 2008? Is there a way to write the url or path of the remote server in order to save the backup file? example: \\1.2.3.4\.... something like that?
i dont know whether your problem is solved or not but just allows remote connections and connect to your remote server , and take backup you can also create jobs/ schedules to do this and database mirroring is also an option , you can also config emails in case of a db backup failure , simple
Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it
-
i dont know whether your problem is solved or not but just allows remote connections and connect to your remote server , and take backup you can also create jobs/ schedules to do this and database mirroring is also an option , you can also config emails in case of a db backup failure , simple
Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it
-
thanks a lot, I did that using a job that takes a backup every 1 hour daily. The problem is that FTP is blocked on the server so I can't transfer the backup file to another server. Do you have any idea how to do that withour FTP? thanks in advance
Did you try Database Mirroring or copy database , their are also large number of utilities available for taking backup and can FTP or email http://www.freedownloadsplace.com/Products/38854/SQLBackupAndFTP[^] http://www.freedownloadscenter.com/Utilities/Backup_and_Copy_Utilities/SQL_Server_Backup.html[^]
Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it
-
Did you try Database Mirroring or copy database , their are also large number of utilities available for taking backup and can FTP or email http://www.freedownloadsplace.com/Products/38854/SQLBackupAndFTP[^] http://www.freedownloadscenter.com/Utilities/Backup_and_Copy_Utilities/SQL_Server_Backup.html[^]
Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it
-
You are Welcome
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
Vuyiswa Maseko wrote:
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/[IGI](http://projectigigame.com)/itsabacus/
need more information about it if possible.
-
Vuyiswa Maseko wrote:
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/[IGI](http://projectigigame.com)/itsabacus/
need more information about it if possible.
Which info do you need ?
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vimalsoft.com vuyiswa[at]vimalsoft.com