Saturday, July 27, 2013

[MS SQL Server] Need to remove reference to a data file -- database will not start

[MS SQL Server] Need to remove reference to a data file -- database will not start

Need to remove reference to a data file -- database will not start

Posted: 26 Jul 2013 02:36 PM PDT

I had added a secondary data file to a database. We migrated environments, and the physical drive that I unknowingly created the secondary file on was destroyed w/o backup. I can rebuild the data contained therein (i had only created this 3 weeks ago), but I cannot get the database to start due to the missing file. All other databases in the named instance start up fine.How can I remove the references to this data file so that the database will start up using only the primary data and log files? I've searched everywhere for a disk or registry resident startup config that I can edit. Please help - this is a huge mess!Thanks,Dave

Backup Failed because of error 0xC0010014

Posted: 14 Jun 2013 04:43 PM PDT

Hi,Backup jobs failed frequently due to as below error.. after resarting server backup jobs running fine..Pl. suggestion me if any pacth or CU are need to apply..Current verion- SQL2K8 32 bitService pack - SP3Error messages[code="other"]Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:10:00 AM Error: 2013-06-15 00:10:01.31 Code: 0xC0010018 Source: Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property DTS:Name="ObjectName">Local server connection</DTS:Property> <DTS:Property DTS:Name="DTSID">{11A126D7-9C4A-417A-9" from node "DTS:ConnectionManager". End Error Could not load package "Maintenance Plans\DB_Backup" because of error 0xC0010014. Description: One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors. Source: Started: 12:10:00 AM Finished: 12:10:01 AM Elapsed: 0.421 seconds. The package could not be loaded. The step failed.[/code]

Generate job script from existing jobs

Posted: 26 Jul 2013 06:13 AM PDT

We have around 40+ jobs in the server box which hosts 5 DB instances, of which i need to script some of the jobs to be run on a different server for testing.I need all the jobs which use a particuler DB only .Is there any Way i can filter and genrate scripts from SQLAgent, If i give a 'wordsearch' like the DB name ,Please advice....
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog