SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Native backup utility in SQL server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Razzle00
Starting Member

35 Posts

Posted - 03/18/2011 :  11:54:18  Show Profile  Reply with Quote
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 Express

SQL 2008 Workgroup Edition

SQL 2008 Standard Edition

Could 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

USA
35940 Posts

Posted - 03/18/2011 :  13:01:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
All versions and editions have BACKUP command (well prior to 7.0, it was DUMP command). What specifically more are you looking for beyond the BACKUP command?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Razzle00
Starting Member

35 Posts

Posted - 03/18/2011 :  13:50:52  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35940 Posts

Posted - 03/18/2011 :  13:55:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
Here you go: http://stackoverflow.com/questions/487675/how-can-i-schedule-a-daily-backup-with-sql-server-express

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Razzle00
Starting Member

35 Posts

Posted - 03/18/2011 :  16:21:11  Show Profile  Reply with Quote
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.sql

Error 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 default
settings 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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35940 Posts

Posted - 03/18/2011 :  16:28:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
You likely need to pass the -S parameter to the sqlcmd command.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000