Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

scheduling a backup in MS SQL 2005

I installed in a computer the MS SQL 2005 express and I would like to know if I can schedule a backup.

Thanks
0
hidrau
Asked:
hidrau
  • 5
  • 4
2 Solutions
 
ptjcbCommented:
You must use the Windows Scheduler, because there is no SQL Agent.

http://www.sqldbatips.com/showarticle.asp?ID=27
0
 
hidrauAuthor Commented:
Hi ptjcb, I tried your example but I have this message when I ran the command line
Sqlcmd -s.\tecnologia01\sql2005 -i"c:\bk\bkmaster.sql"

tecnoligia01\sql2005  = this is my database name

Named pipes provider: could not open a connection to SQL server [2]
Sqlcmd: error : microsoft sql native client]: an error has accurred while establishing a connection
to the server. When connection to Sql Server 2005, this failure may be caused by
the fact that the default setting to SQL server does not allow remote connections
Sqlcmd error Microsoft SQL native client: login timeout expired

Sqlcmd -s.\tecnologia01\sql2005 -i"c:\bk\bkmaster.sql"
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
ptjcbCommented:
OK, obvious question, do you have SQL Server configured to accept remote connections?
0
 
ptjcbCommented:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Gives you instructions on how to do that (if you haven't already).
0
 
hidrauAuthor Commented:
I am doing this im my own machine where ms sql 2005 is installed. Even though I need to do this?
0
 
ptjcbCommented:
Yes.
0
 
hidrauAuthor Commented:
snifff I didn't get it the same error
0
 
hidrauAuthor Commented:
my tcp ip is enable
0
 
hidrauAuthor Commented:
how can I run a sql script by DOS like I was trying to do with sqlcmd

this can be the solution
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now