Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Razzle00
Starting Member
35 Posts |
 Posted - 2011-03-18 : 11:54:18
|
| Hi, I am trying to find information on which SQL server version have a native backup utility to schedule and create backup files of the databases in SQL server. But I am not getting a clear definition of what backup capabilities each version has. I have checked Microsoft's web site on version comparisons, but its not be real informative on this issue. The versions I am in question on are the following:SQL 2008 ExpressSQL 2008 Workgroup Edition SQL 2008 Standard EditionCould anyone with experience using these version tell me what backup capabilities they have. And if they do not have any what suggestions do you have for backing up the databases.Thanks,Razzle |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Razzle00
Starting Member
35 Posts |
Posted - 2011-03-18 : 13:50:52
|
| Hi tkizer, In SQL standard edition, if you expand Management, then right click on Maintenance you can setup a task that can backup your databases to any destination based on a schedule or date range. Just wondering if SQL Express and SQL Workgroup Editions have this feature. I realize they all have a backup command, but I cannot schedule automatic backups natively in the other versions lower that Standard edition. Or am I wrong and you can? That is my question.Thanks,Razzle |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Razzle00
Starting Member
35 Posts |
Posted - 2011-03-18 : 16:21:11
|
| Thanks again for the response tkizer.I am trying some of the suggestions from the link you gave me. One which says you can run a script from the task scheduler. However, when I try to run the script SQL express returns this error.Command for script is:C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqlcmd.exe -i C:\Backupsql\folder1\backup.sqlError returned is:Named Pipes Provider: Could not open connection to SQL Server [2].Sqlcmd: Error: Microsoft SQL Native Client : 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 defaultsettings in SQL Server does not allow remote connections..Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.Any ideas as to what settings need to be changed to allow this command to work? I have scanned through the configuration manager looking for a place to allow remote connections and anything pertaining to remote connections say active.Thanks,Razzle |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Native backup utility in SQL server