-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
A scheduled transaction log backup failed. I scripted the failing statement and re-ran the command in SSMS (this is a dev server). The command: BACKUP LOG [GLPart] TO DISK = N’T:\SQBACK\Default\GLPart_backup_2012_08_30_111114_9999915.trn’ WITH NOFORMAT, NOINIT, NAME = N’GLPart_backup_2012_08_30_111114_9999915′, SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10 failed with the following error message: Processed 1 pages for database … Continue reading
I have seen a number of SQL Server instances where multiple jobs have been created with no real thought for the job name. Especially in systems with lots of jobs, this causes a degree of confusion, as it becomes difficult to quickly identify which jobs are associated with which database. To simplify maintenance, use a … Continue reading
To run a package from the SQL Server Agent and pass in a parameter, Create a SQL Server Agent Job as usual. The Job Step Type is “SQL Server Integration Services Package”. In my example, the Package source is “File System”. Select the package location and then move to the Command Line tab. Add the … Continue reading
When creating a Listener for an AlwaysOn Availability group, I received the below error: Msg 19471, Level 16, State 0, Line 1 The WSFC cluster could not bring the Network Name resource with DNS name ‘LNSxxx’ online. The DNS name may have been taken or have a conflict with existing name services, or the WSFC … Continue reading
ittreasure 