Posted: 01 Sep 2013 04:20 PM PDT

HiI have a gender column like this:Gender--------FAAAMnullFMnullCan some give me an idea how can I create and implement a strategy to fill the missing/incorrect values for the gender column

Backup job fails but maintenance plan succeeds

Posted: 29 Nov 2011 12:20 AM PST

The backups are in the desired destination, they restore just fine, and the maintenance plan log reports no errors.The agent job fails, but there are so many backups in the plan that there is no useful error information. I've pasted the step log here, unfortunately it is long but at the bottom you can see an error, but nothing that says why the job is failing:[code="plain"]Date 11/29/2011 2:00:00 AMLog Job History (User Databases Full Backup Plan.Subplan_1)Step ID 1Server xxxJob Name User Databases Full Backup Plan.Subplan_1Step Name Subplan_1Duration 00:37:23Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: xxx\xxx. ...on 10.0.1600.22 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:00:00 AM Progress: 2011-11-29 02:00:01.07 Source: {196E9554-8336-487A-A0F2-F002F92CCB12} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2011-11-29 02:00:03.78 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 7% complete End Progress Progress: 2011-11-29 02:00:03.78 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 14% complete End Progress Progress: 2011-11-29 02:00:03.79 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 21% complete End Progress Progress: 2011-11-29 02:00:03.79 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 28% complete End Progress Progress: 2011-11-29 02:00:03.79 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 35% complete End Progress Progress: 2011-11-29 02:00:03.79 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 42% complete End Progress Progress: 2011-11-29 02:00:03.79 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 50% complete End Progress Progress: 2011-11-29 02:00:03.79 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 57% complete End Progress Progress: 2011-11-29 02:00:03.79 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 64% complete End Progress Progress: 2011-11-29 02:00:03.81 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 71% complete End Progress Progress: 2011-11-29 02:00:03.81 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 78% complete End Progress Progress: 2011-11-29 02:00:03.81 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 85% complete End Progress Progress: 2011-11-29 02:00:03.81 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 92% complete End Progress Progress: 2011-11-29 02:00:03.81 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'\\xxx\bac...".: 100% complete End Progress Progress: 2011-11-29 02:14:10.75 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [xxx] TO DISK = N'\\xxx\backup...".: 100% complete End Progress Progress: 2011-11-29 02:36:09.81 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [xxx] TO DISK = N'\\xxx...".: 100% complete End Progress Progress: 2011-11-29 02:36:15.84 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [xxx] TO DISK = N'\\xxx\back...".: 100% complete End Progress Progress: 2011-11-29 02:36:17.12 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [xxx] TO DISK = N'\\xxx\...".: 100% complete End Progress Progress: 2011-11-29 02:36:21.36 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [xxx] TO DISK = N'\\xxx...".: 100% complete End Progress Progress: 2011-11-29 02:36:21.87 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [xxx] TO DISK = N'\\xxx\back...".: 100% complete End Progress Progress: 2011-11-29 02:36:33.00 Source: Back Up Database (Full) Ex... The package execution fa... The step failed.[/code]The system db backup job succeeds. The differential jobs between the full backups succeed. This is not a terrible crisis, as the full backups themselves are actually succeeding, but it raises my blood pressure to come in every morning and see that my backup jobs have failed, and it wastes my time having to go check that they did not actually fail but rather agent threw up on me. This has been happening for about a week.Any suggestions??

export to csv

Posted: 01 Sep 2013 09:08 AM PDT

Hi ProfessionalsI have a script thats exports to a csv file[code]exec exporttocsv 'select top 5 * from newtable', 'test.csv'[/code]the problem I am encountering is that some of the csv files are over 100MB making it virtually impossible to open, manipulate or email to work colleagues.i am sure it is possible but do not know the correct syntax but is there a way to select say the first 100,000 rows then the next 100,000 rows and so on then finallly however may rows are left into more than one csveg[code]exec exporttocsv 'select top 100 * from newtable', 'test.csv'exec exporttocsv 'select NEXT100,000 rows from newtable', 'test1.csv'exec exporttocsv 'select REMAINING rows from newtable', 'test2.csv'[/code]

windows installer fot sql installation

Posted: 31 Aug 2013 10:38 PM PDT

why do one require windows installer for installing sql 2005/2008 setup.

BIDS Debug issue with single solution

Posted: 01 Sep 2013 01:09 AM PDT

This is driving me nuts. I hope someone can assist me with the resolution.Out of the dozens and dozens of SSIS solutions we have at the office, only one solution does this. When I open the solution, open a single package and try to debug that package, the solution opens up other packages and starts running those instead.Now this solution is unique in that I have multiple projects. One for SSIS packages, and one for SSRS objects. But the SSRS objects aren't even opening. This is the SSIS project only that has this issue and none of our other SSIS solutions / projects have this problem.Can someone point me to what setting or problem I might be having that could cause this? It's getting so bad that I have to remember to export the package to a misc. solution in order to fix any issues then import the package back into that solution on top of the old copy.

Sql samples, sql tips

Monday, September 2, 2013

[SQL Server 2008 issues] fill the missing/incorrect values for the gender column

[SQL Server 2008 issues] fill the missing/incorrect values for the gender column

No comments:

Post a Comment

Search This Blog