Navigation
Home
Products
Articles
About Us
 

Installation Questions

Category: LazyCoding.com - SQLScheduler Posted On: March 15, 2007


Please post your installation questions and issues here.


Feedback by other visitors of LazyCoding.com

On Thursday March 15, 2007 11:49:00 Josh said:

I installed the service and ran executed a job. When trying to execute it was looking to place a .log file in c:\SQLSched2\Service\Logs.
The zip package did not create that folder, I manually created it and all is well.

On Friday March 16, 2007 06:13:56 Stephen said:

Some problem here..

v0.2.0.0
Create a folder called "Logs" in the Service folder and it works great!

On Friday March 16, 2007 09:32:22 LazyCoding.com said:

WinZip omits empty folders by default, so the Logs directory did not get included into the package.

Sorry for the trouble, it is now fixed.

-LazyCoding.com

On Thursday March 22, 2007 05:55:58 John said:

Hi, Great product. However I have a syntax problem with the SQL statement. This is what I have coded....

DECLARE @BackupName VARCHAR(255)
DECLARE @BackupFileName VARCHAR(255)

SET @BackupName = 'insitetimandnaomi_' + convert(nvarchar(20), getdate(), 112) + N'.bak'
SET @BackupFileName = N'd:\virtualservers\databases\' + @BackupName

BACKUP DATABASE insite-timandnaomi TO
DISK = @BackupFileName WITH NOFORMAT, NOINIT,
NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10

The syntax error displays this....
"Incorrect syntax near '-'.
Incorrect syntax near the keyword 'with'."

Any Ideas?

On Thursday March 22, 2007 06:34:18 John said:

Ok - Have solved this by renaming the DB without the hyphen.
I have also changed the backup syntax to show "WITH FORMAT"
Will this type of backup be a full backup?

On Thursday March 22, 2007 08:29:10 LazyCoding.com said:

Hi John,

1) I haven't tried this but using brackets should've solved the dash problem you were having before.

BACKUP DATABASE [insite-timandnaomi] TO ...

2) The FORMAT | NOFORMAT options are typically only used when backing up onto tapes, or when you are stripping backup accross mulitiple data files. In either case, a complete backup will be performed unless you specify the DIFFERENTIAL option.

On Wednesday March 28, 2007 06:32:32 Myles said:

I'm getting "System.BadImageFormatException: The format of the file 'SQLSchedular.WindowsService.exe' is invalid" when I try to run 'installservice.bat'. Any ideas ?

On Wednesday March 28, 2007 08:19:15 LazyCoding.com said:

Hi Myles,

Do you have .NET Framework 2 installed?

Please make sure that "installservice.bat" runs the "installutil.exe" file from the .NET Framework 2.0 folder and not any other older versions.

On Wednesday March 28, 2007 09:03:34 Myles said:

.NET Framework 2 is installed but it was using an older version of installutil.exe.

Thanks

On Thursday April 12, 2007 02:57:17 Dick said:

Hi, Installed your product which worked fine untill the service gets started. I get a system error 1067 (and SQLScheduler Service-Service can't be started, process ended unexpectedly) Any ideas what went wrong? Thanks in advance, Dick

On Thursday April 12, 2007 04:14:56 LazyCoding.com said:

Hi Dick,

Please take a look for any errors in the Applicatoin/System event logs. There should be an event record with more information.

Thanks

On Friday April 13, 2007 07:39:55 Dick said:

Hi, I checked but there's no additional info in the eventlog record. Thanks anyway, Dick

On Wednesday April 25, 2007 11:11:50 Igor said:

Installed your product which worked fine untill the service gets started. I get a system error 1067 (and SQLScheduler Service-Service can't be started, process ended unexpectedly)
Error in the Applicatoin/System event logs:
EventType clr20r3, P1 sqlscheduler.windowsservice.exe, P2 0.2.0.0, P3 45dd34e7, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 51e4, P8 61, P9 n51cffzwz1gffvslvrub5uxq1gvd0txu, P10 NIL.
I have Windows2000 SP4 (Russian Version)

On Wednesday April 25, 2007 02:03:53 LazyCoding.com said:

Igor,

Please open the SQLScheduler.WindowsService.exe.config file with notepad and make sure that the 'authorizedGroup' attribute
points to valid group name in your localized version of Windows.

.. channel ref="ipc" portName="SQLSchedulerServerPipe" ...

... authorizedGroup="everyone" ...

In your case, replace "everyone" with a Russian version of this group name.

On Wednesday April 25, 2007 10:22:29 Igor said:

Thank you for help me
In SQLScheduler.WindowsService.exe.config file it happened to indicate code page
<?xml version="1.0" encoding="WINDOWS-1251" ?>

On Wednesday May 16, 2007 07:46:31 Phil said:

Installed the product yesterday and very impressed. Yoday, however I went to add a new job and I just get -

SQLScheduler.GenericException: There appears to be a problem with the connection to the SQLScheduler Service. Please make that the service is up and running. ---> System.Runtime.Remoting.RemotingException: Failed to connect to an IPC Port: The system cannot find the file specified.

Any Ideas?

On Wednesday May 16, 2007 11:35:32 LazyCoding said:

Hi Phil,

Please check that the SQLScheduler Windows service has been started on the machine where you are running the SQL Scheduler.

On Thursday May 17, 2007 05:54:48 Phil said:

All sorted thanks - Someone had restarted my server without telling me.......... heads will roll....!

On Tuesday June 12, 2007 03:47:21 Arti said:

I get this error when i execute the scheduler job i just created.
The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3201
on line 1 of procedure on server TPAPP03\SQLExpress,1642:
Cannot open backup device 'F:\Bakups\CH_LibertyIMS.bak'. Operating system error 3(The system cannot find the path specified.).
The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3013
on line 1 of procedure on server TPAPP03\SQLExpress,1642:
BACKUP DATABASE is terminating abnormally.
------------------------------------------------
I get the same error when I run it from management studios.

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'F:\Bakups\CH_LibertyIMS.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

On Wednesday June 13, 2007 02:31:42 LazyCoding.com said:

Arti,

Make sure that path is valid, and check the security permissions on the folder you are trying to backup to. Make sure the service account (Network Service) has write permissions. It may well not do.

On Friday June 29, 2007 07:12:05 Girish said:

As suggested "Please check that the SQLScheduler Windows service has been started on the machine where you are running the SQL Scheduler.". I did that and I get the info that "Service got started and stopped as there was no work to do".How can this be sorted?

On Monday July 09, 2007 03:51:52 Dave said:

It appears that the cyphervalue in the jobs.config file is different based on what computer it is installed on. Is there a way to get around that so that we can use a general jobs.config file to distribute among different computers so we don't have to create the jobs manually each time we deploy your program?

Thanks in advance.

On Monday November 19, 2007 03:38:14 Alessandro said:

When it tries to backup my 160MB database automatically, it says "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.". I suspect that is a problem associated with the timeout of the Command object.

On Monday November 19, 2007 09:20:38 LazyCoding.com said:

Alessandro,

Just increase the Timeout value for the job, it's on the job's properties screen.

On Tuesday November 20, 2007 02:52:14 Gene said:

Getting this erro in log file when executing:

Fusion DB full backup(11/20/2007 11:49:23 AM): Job started.
Fusion DB full backup(11/20/2007 11:49:23 AM): Job finished. Status : Failed
Fusion DB full backup(11/20/2007 11:49:23 AM): Run results : The .Net SqlClient Data Provider has received a severity 15, state 1 error number 102
on line 9 of procedure on server everest:
Incorrect syntax near '='.

Here is details of the job backing up to local disk. I have tried removing "SKIP, REWIND, NOUNLOAD, STATS = 10" but get same error:

DECLARE @BackupName VARCHAR(255)
DECLARE @BackupFileName VARCHAR(255)

SET @BackupName = 'Fusion_' + convert(nvarchar(20), getdate(), 112) + N'.bak'
SET @BackupFileName = N'e:\acct\backups\' + @BackupName

BACKUP DATABASE Fusion TO
DISK = @BackupFileName
NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10

On Tuesday November 20, 2007 07:53:35 LazyCoding.com said:

Gene,

I suspect you are missing a comma after DISK=@BackupFileName:

BACKUP DATABASE Fusion TO
DISK = @BackupFileName,
NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10

On Wednesday November 21, 2007 12:04:42 Gene said:

Added the comma after@BackupFileName and now get this error:


Fusion DB full backup(11/20/2007 8:47:39 PM): Job started.
Fusion DB full backup(11/20/2007 8:47:39 PM): Job finished. Status : Failed
Fusion DB full backup(11/20/2007 8:47:39 PM): Run results : The .Net SqlClient Data Provider has received a severity 15, state 1 error number 155
on line 9 of procedure on server everest:
'NAME' is not a recognized Device Type option.

On Wednesday November 28, 2007 12:05:23 Gene said:

Made these changes and now no syntax errors.

DECLARE @BackupName VARCHAR(255)
DECLARE @BackupFileName VARCHAR(255)

SET @BackupName = 'Fusion_' + convert(nvarchar(20), getdate(), 112) + N'.bak'
SET @BackupFileName = N'e:\acct\backups\' + @BackupName

BACKUP DATABASE Fusion TO
DISK = @BackupFileName WITH NOFORMAT, NOINIT,
NAME = @BackupName

But I now get several invalid column name errors during backup. It does run but appends to last backup. Would like to resolve errors and have backup delete previous one or just create a new one. The last few lines are:

The .Net SqlClient Data Provider has received a severity 16, state 1 error number 207
on line 7 of procedure on server everest:
Invalid column name 'is_present'.
The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3009
on line 7 of procedure on server everest:
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with

On Wednesday November 28, 2007 04:28:04 LazyCoding said:

Gene, check that your MSDB is not full. Either the database itself or the transaction log.

On Friday November 30, 2007 04:43:18 Mike F said:

Great product! My only complication is that I cannot get the e-mail notification function to work. I have updated the information as stated below:

<smtp deliveryMethod="Network" from="sqlscheduler@omd.com">
<network host="130.0.1.1" userName="" password="" />
</smtp>

Can you help?

On Sunday December 09, 2007 10:11:13 Lazycoding.com said:

Mike,

Check the SQLScheduler log files for errors. Also make sure that the mail server accepts relaying from the machine that is running SQLScheduler, otherwise, you might need to specify a valid account name and password.

On Sunday December 23, 2007 07:49:57 Tolga said:

Great Product, so first of all I thank you very much. I got it set up and running smoothly, however I have a question about the size of .bak file the program backs up. In my case the .bak file is 112 MB while if full backup done manually within SQL EXPRESS weighs 27 MB. And also, if I compress 112 MB .bak file using winrar it goes down to 8 MB. So my question is this: can we add a line to the SQL Template to compress and minimize the size of the backup following the backup job? Because this will be a great help for people like me who is also uploading the backup file using FTP to a remote server every night.
Thanks again

On Sunday December 23, 2007 10:27:05 LazyCoding.com said:

Tolga,

Take a look at the http://www.lazycoding.com/articles/sql_scheduler_feedback_19.aspx article. In one of the comments I explain how to compress the back up file with Winrar. Also the backup file created by SQLScheduler should be pretty much exactly the same as the one done by the Management Studio. The file size difference may depend on a number of settings: Transaction Log backup, complete vs differential, one backup per file vs appending backups, etc. In the end SQLScheduler only executes the command that given to it, which means that the SQL Management Studio must be running a slightly different SQL Script.


Cheers and Merry X-mas

On Monday December 24, 2007 05:31:02 Tolga said:

Got it! Thanks again.

Happy Holidays...

On Tuesday December 25, 2007 03:24:15 Tolga said:

Hello again; I have read and modified my code as you see below in order to compress my database backup using winrar. Everything goes through smoothly, backup is completed with no errors and I receive the email of backup succession. However, The WINRAR backup section of the code does not execute, because right after I go and check the \ZIPPEDBACKUPS\ folder where I expect the backup should be, and the folder is empty. Could you please help me to resolve this issue?
Briefly, my final goal is to have my daily databse backups compressed by winRAR in my ZIPPEDBACKUPS folder, because then I will schedule FTP uploads of these compressed backups every night to my FTP server.

Note: my server settings cmdshell is ENABLED by the way, and my entire syntax checks out and backup is a success everytime.


______________ SQL Template I am using within SQL Scheduler Program___________________

DECLARE @BackupName VARCHAR(100)
DECLARE @BackupFileName VARCHAR(100)
DECLARE @BackupPath VARCHA

On Tuesday December 25, 2007 03:26:19 Tolga said:

.... continues from above
______________ SQL Template I am using within SQL Scheduler Program___________________

DECLARE @BackupName VARCHAR(100)
DECLARE @BackupFileName VARCHAR(100)
DECLARE @BackupPath VARCHAR(1000)

SET @BackupName = 'ATR30DB_' + convert(nvarchar(20), getdate(), 112)
SET @BackupFileName = @BackupName + N'.bak'
SET @BackupPath = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\' + @BackupFileName

BACKUP DATABASE ATR30DB TO
DISK = @BackupPath WITH NOFORMAT, NOINIT, DIFFERENTIAL,

NAME = @BackupFileName, SKIP, REWIND, NOUNLOAD, STATS = 10

DECLARE @ArchiveName VARCHAR(1000)
Set @ArchiveName = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\archive.bat' + @BackupName

exec xp_cmdshell @ArchiveName

On Tuesday December 25, 2007 03:26:44 Tolga said:

continues from above....

______________archive.bat File Content As Follows Below ____________


C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ZIPPEDBACKUPS

"C:\Program Files\WinRAR\rar.exe" a -df -rr1 %1 %1.bak

_________________________________________________________

On Friday December 28, 2007 03:56:05 LazyCoding.com said:

Tolga,

Looks like your batch file is a bit off. First, I would actually recommend to create a directory somewhere in the root of the drive called "backups" and put all the files there, instead of using the default ...Program Files\... path. It just makes things easier and cleaner, and you don't need to worry about quotes if there is a space inside a filename.

So based on the example above, your batch file should be something like this:

____________________
cd "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ZIPPEDBACKUPS"

"C:\Program Files\WinRAR\rar.exe" a -df -rr1 %1 ..\Backup\%1.bak
___________________

On Sunday December 30, 2007 10:38:49 Tolga said:

Thank you very much once more and I wish you a happy new year!... Cheers :-)

On Monday January 14, 2008 04:07:31 ZeMotard said:

Hi, when I check my sql request, this message appears, could you help me to solve it ?
Regards

System.Data.DataException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

On Monday January 14, 2008 10:17:37 LazyCoding.com said:

ZeMotard,

Check the server name, ip address, instrance name of the SQL Server you are connecting too. And if SQL Server is on a different machine than SQLScheduler, make sure that SQL Server can be accessed remotely.

On Tuesday January 15, 2008 04:20:39 zemotard said:

It's an the same machine. IP / database name are ok ....

On Wednesday January 16, 2008 11:23:18 ZeMotard said:

It's working, it was a bad name server ....
Regards

On Friday February 01, 2008 02:43:54 Ed said:

I am getting an error error when checking the syntax 'The tpye initalizer for "System.Data.SqlClient.SqlConnection' threw an exception.

When I Execute the job I get the error "System.NullReferenceException: Object reference not set to an instance of an object.
at SQLScheduler.Services.JobService.WorkerCompleted(BaseWorker p_objWorker)" in the last line of the logs.

Thanks.

On Friday April 18, 2008 10:51:12 brrfpuavfo said:

GIcfmC <a href="http://qdwyxlptxdaa.com/">qdwyxlptxdaa</a>, [url=http://soytzxqoftdt.com/]soytzxqoftdt[/url], [link=http://zhchijzbcywn.com/]zhchijzbcywn[/link], http://pzddrydqunbn.com/

On Tuesday May 27, 2008 04:34:38 Michael said:

Hello,
Let me start by saying that your software is fantastic, fits my exact needs perfectly glad to see that there is still some good freeware for windows still.

I only have one issue it seems to be small but when I backup one of my databases I get this error:

Sutie Backup(5/27/2008 1:29:34 PM): Job started.
Sutie Backup(5/27/2008 1:29:51 PM): Job finished. Status : Succeeded
Sutie Backup(5/27/2008 1:29:51 PM): Run results : 10 percent backed up. (Severity 0, state 1, error number 3211, line 7)
20 percent backed up. (Severity 0, state 1, error number 3211, line 7)
30 percent backed up. (Severity 0, state 1, error number 3211, line 7)
40 percent backed up. (Severity 0, state 1, error number 3211, line 7)
50 percent backed up. (Severity 0, state 1, error number 3211, line 7)
60 percent backed up. (Severity 0, state 1, error number 3211, line 7)
70 percent backed up. (Severity 0, state 1, error number 3211, line 7)
80 percent backed up. (Severity 0, state 1, error number

On Tuesday May 27, 2008 07:07:44 LazyCoding.com said:

Michael,

These are just informational messages/warnings.

On Tuesday June 10, 2008 02:07:56 Chris Backer said:

C:\Documents and Settings\Administrator\Desktop\SQLScheduler_LatestVersion\Servi
ce>installservice.bat
Installing WindowsService...
---------------------------------------------------
'InstallUtil' is not recognized as an internal or external command,
operable program or batch file.
---------------------------------------------------
Starting...
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.


this is what i am getting when i run the installservice.bat file.

i have .net framework 2.0 installed and verified the folder it's looking for......

On Tuesday June 10, 2008 05:40:52 LazyCoding.com said:

Hi Chris,

Just open up the installation batch file and replace the path to installUtil.exe with the valid path on your machine. It should be in the Windows directory under Microsoft.Net folder.

On Tuesday June 17, 2008 02:16:53 Ben said:

Been looking for something like this for ages!!
But I have had a few problems and would love some help please.
Installation fine, restarted service no problem.
I have more than 1 database running under the MSDE instance, can I narrow in on backing up just one?

I have set the following job details:

DECLARE @BackupName VARCHAR(255)
DECLARE @BackupFileName VARCHAR(255)

SET @BackupName = connx_' + convert(nvarchar(20), getdate(), 112) + N'.bak'
SET @BackupFileName = N'D:\ConnX_Backup\' + @BackupName

BACKUP DATABASE connx TO
DISK = @BackupFileName WITH NOFORMAT, NOINIT,
NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10

However I get the following error bfore I can even save the job:

SQLScheduler.GenericException: Job 'ConnX' does not exist for server 'SERVER-04\MERIDIEN'.

Server stack trace:
at SQLScheduler.Services.JobService.GetJobConfig(String serverName, String jobName)
at SQLScheduler.Services.JobService.CheckSQLSyntax(String serverNam

On Tuesday June 17, 2008 02:17:55 Ben said:

Oops it doesnt all fit! Error I get it:

SQLScheduler.GenericException: Job 'ConnX' does not exist for server 'SERVER-04\MERIDIEN'.

Server stack trace:
at SQLScheduler.Services.JobService.GetJobConfig(String serverName, String jobName)
at SQLScheduler.Services.JobService.CheckSQLSyntax(String serverName, String jobName, String script)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessa

On Monday June 23, 2008 05:32:31 Mark said:

I am new to this tool, it is a very nice tool. I have the following SQL script that I would like to run scheduled:

INSERT INTO table1 ( ID1 )
SELECT table2.ID2 FROM table2;

UPDATE table1 SET table1.table1date = CONVERT(VARCHAR,GETDATE(),101)
WHERE table1.table1date Is Null;

How do I go about this?

On Tuesday June 24, 2008 10:18:04 Rajendra said:

I am unable to install the SQL Express edition on P3 machine...
I got following error -

"error 1603 installing microsoft sql server 2005 setup support file"

Any Idea how do i overcome this error?

On Thursday July 03, 2008 10:11:44 Densil said:

I tried to sutup a job and go the following error:

Failed to decrypt using provider 'DataProtectionConfigurationProvider'. Error message from the provider: Key not valid for use in specified state. [Exception from HRESULT: 0x8009000B] [D:\SQLScheduler_LatestVersion\Service\jobs.config line

Any ideas?

On Thursday July 31, 2008 07:46:30 Dmitriy Zasyatkin said:

I just wanted to say thank you so much for providing this great tool. It has been an excellent replacement for SQL Server Agent.

I hope you will consider making it an open source project and hosting it on SourceForge.net or CodeProject.com so that it will continue to evolve. Thanks and keep up the great work.

On Monday September 15, 2008 04:06:23 Caroline said:

http://basketball-9.uqiune.net http://basket-1.uqiune.net http://bat-6.uqiune.net http://barry-8.uqiune.net http://baseball-7.uqiune.net http://basic-2.uqiune.net http://basement-3.uqiune.net http://basket-2.uqiune.net http://baseball-42.uqiune.net http://basket-6.uqiune.net http://based-6.uqiune.net http://basketball-21.uqiune.net http://basketball-16.uqiune.net http://basket-13.uqiune.net http://bass-11.uqiune.net http://base-19.uqiune.net http://baseball.uqiune.net http://basketball-12.uqiune.net http://basketball-19.uqiune.net
http://basketball-27.uqiune.net

On Tuesday September 23, 2008 05:26:02 andhi said:

SET @BackupFileName = N'D:\ConnX_Backup\' + @BackupName

whould you make skript if
Backup File in another Computer
Ex:
\\Andhi\Backup\

On Sunday October 05, 2008 04:49:53 Ira said:

http://doxazosin.pharmstoreworld.net http://quickbust.pharmstoreworld.net http://avapro.pharmstoreworld.net http://plan-b-68.pharmstoreworld.net http://pilocarpine.pharmstoreworld.net http://cha-de-bugre.pharmstoreworld.net http://pharmstoreworld.net http://mentat.pharmstoreworld.net http://pets-8.pharmstoreworld.net http://nitrofurantoin.pharmstoreworld.net http://phentrimine.pharmstoreworld.net http://avodart.pharmstoreworld.net http://mircette.pharmstoreworld.net http://accutane.pharmstoreworld.net http://ortho-tricyclen.pharmstoreworld.net http://citalopram.pharmstoreworld.net http://anabolic.pharmstoreworld.net
http://tentex-royal.pharmstoreworld.net

On Monday October 20, 2008 04:18:43 Internet pharmacy with FedEx overnight shipping an said:

<a href="http://www.drugshome.com/index.php">Internet pharmacy with FedEx overnight shipping and free prescription</a> http://DrugsHome.com

On Wednesday October 22, 2008 11:14:51 ddd said:

The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3007
on line 7 of procedure on server 192.168.1.250:
파일 또는 파일 그룹 "iView"은(는) 온라인 상태가 아니므로 백업할 수 없습니다. FILEGROUP 또는 FILE 절을 사용하여 선택 항목에 온라인 데이터만 포함되도록 제한하여 BACKUP을 수행할 수 있습니다.
The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3013
on line 7 of procedure on server 192.168.1.250:
BACKUP DATABASE이(가) 비정상적으로 종료됩니다.

On Thursday October 23, 2008 11:46:40 Theodora said:

http://candid-2.zenavo.cn http://health-52-393.zipace.cn http://solution-14-787.zyreloj.cn http://drug-1-629.zipace.cn http://herbal-7-371.zipace.cn http://droncit.zenavo.cn http://nursing-32-250.zostura.cn http://bedding-4.zenavo.cn http://hair-loss-352.zipace.cn http://yasmin.zyreloj.cn http://vitamin-5.zyreloj.cn http://flextra.zipace.cn http://nursing-31-200.zostura.cn http://quinapril-647.zuvexry.cn http://panoxyl-848.zostura.cn http://evecare.zenavo.cn http://temazepam.zuvexry.cn http://weight-loss-7.zyreloj.cn http://pregnancy-13-183.zuvexry.cn http://speed-1-571.zyreloj.cn
http://solution-35.zyreloj.cn

On Sunday October 26, 2008 05:20:51 grateful user said:

Hi Lazycoding.com. Thank you very much for creating this simple yet absolutely necessary software. As a small company with limited IT budget, it's ppl like you that enables us to compete with the big boys and as a result offer choices to consumers. God bless you!

On Wednesday October 29, 2008 10:28:38 Afzal said:

hi I have downloaded the product for SQL Express 2005 but i find it doesnt seem to work. the program want you to create the job in Express prior to setting up a schedule. Whats the point of that. It would be most helpful if someone could explain how one can create a job via the scheuler as this isnt possible vi aexpress.

On Monday November 03, 2008 12:38:07 Steve said:

Thanks for a great little utility. It's amazing how handy it is.

I'm getting the same informational messages Michael reported. I understand these are just informational messages, but they are making the Scheduled backup trigger the "Failed" message for notifying me with an email. ...Is there a way to turn those informational messages off, or reset and provide an error code in the SQL to make SQL Schedular see it as a success if it completes?

Sutie Backup(5/27/2008 1:29:34 PM): Job started.
Sutie Backup(5/27/2008 1:29:51 PM): Job finished. Status : Succeeded
Sutie Backup(5/27/2008 1:29:51 PM): Run results : 10 percent backed up. (Severity 0, state 1, error number 3211, line 7)
20 percent backed up. (Severity 0, state 1, error number 3211, line 7)
30 percent backed up. (Severity 0, state 1, error number 3211, line 7)
40 percent backed up. (Severity 0, state 1, error number 3211, line 7)

On Wednesday November 19, 2008 06:45:58 Archibald said:

http://dodgecityweather.blog.com http://policecarsandabsbrakes.blog.com http://renaultclioauto1995usersmanual.blog.com http://taylormader7drawhybrid.blog.com http://nissanpathfindersalvagephotos.blog.com http://montanamlslincolncounty.blog.com http://2000bmw750.blog.com http://rollerautoauction.blog.com http://1995gmcsonomapickuptruck.blog.com http://2002chryslerconcordelimitedcustomercomplaints.blog.com http://2003fordtwotonecombinations.blog.com http://edwardmckaysusedbooksandmore.blog.com http://hr20nowhasautotune.blog.com http://camerocars.blog.com http://chryslerworldwi.blog.com http://dodgechryslercity.blog.com
http://jupiteraccidentjaguar.blog.com

On Thursday November 20, 2008 03:32:47 Marco said:

Thank you for use your component, i'm testing it now and works great!

My goal is to have each day one backup file. So i changed your default code to this:

SET @BackupName = 'fileprefix_weekday_' + CAST(datepart(weekday,getdate()) AS nvarchar(20)) + N'.bak'
DISK = @BackupFileName WITH NOFORMAT, INIT,
NAME = @BackupName, SKIP, REWIND, NOUNLOAD, STATS = 10

Means i will have 7 files:

fileprefix_weekday_1
fileprefix_weekday_2
fileprefix_weekday_3
etc

and when it's again weekday 1 the file will be override.

So far so good :)

But but.... I wish there was a way to make this more flexibel, so I can give the maximum number of saved files?

Kind regards
Marco
The Netherlands

On Wednesday December 03, 2008 09:32:48 Brian said:

Thank you for your time and efforts. I see that some of my questions have already been answered but I do have two questions.

1) When I do the backup and it says successful, I look at the c:\backup directory and the size of my backup is 0 KB.
2) For emailing myself, do I need a userid and a password from the network host?

On Sunday December 07, 2008 05:33:04 qtciixm said:

fJt7Na <a href="http://vdtvlxwajruo.com/">vdtvlxwajruo</a>, [url=http://cdiwslixqtok.com/]cdiwslixqtok[/url], [link=http://scxplpnejrrl.com/]scxplpnejrrl[/link], http://htjkuaagovhu.com/

On Friday December 19, 2008 08:56:31 nitin bobade said:

i have same with ur article mr.john

On Friday December 19, 2008 08:58:38 nitin laxman bobade said:

I installed the service and ran executed a job. When trying to execute it was looking to place a .log file in c:\SQLSched2\Service\Logs.
The zip package did not create that folder, I manually created it and all is well.

thanks & regards
9867953801

We want to hear what you have to say about this article!

New Comment

 
[Login]