Showing posts with label location. Show all posts
Showing posts with label location. Show all posts

Tuesday, March 20, 2012

Scheduled Jobs

When creating a scheduled job is it possible to output the file to a shared drive on the network
When browsing for file location whien creating the job only local physical drives are shown and when inputting unc share the job fails
any ideas ?If you know the name/IP address of the network file then you can output the file by using:

\\servername\d$\data\filename.dat

where 'd$' is the drive you're writing to on that server.

(NB This doesn't work if you are doing any file handling using the Scripting Runtime DLL through T-SQL)

Friday, March 9, 2012

Scheduled backup does not run

I used the backup wizard to create a recurring backup to disk, but the the w
hen I look at the location where the backup file is to be created, I see tha
t it does not run. What am I doing wrong?Is the SQL Server Agent service started?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Jack Wachtler" <jack_wachtler@.comcast.net> wrote in message
news:4E4DF6C6-0DD1-430A-95CE-2713AA1D4030@.microsoft.com...
> I used the backup wizard to create a recurring backup to disk, but the the
when I look at the location where the backup file is to be created, I see
that it does not run. What am I doing wrong?|||I started the agent. Thanke for helping out a newbie.