April 14, 2012 at 10:03 am
I am trying to build new server SQL 2008 R2 64 bit, and want to import all the databases and jobs, can I do it faster like importing with one command,
Please Assist
April 14, 2012 at 2:09 pm
as this is a one off task you can script out all the jobs using SSMS.
select jobs in the left hand pane. select F7 and you will see the jobs listed in the right hand pane, you cam then select all the jobs, right click on them and select script jobs.
this script can then be run in your new instance, you may want to replace all references to server name first. I would advise against copying over maintenance plan jobs but instead create from scratch.
As for databases use backup\restore to copy them across.
---------------------------------------------------------------------
April 15, 2012 at 1:38 pm
If you have Integration services installed, you can quickly use that to export the jobs. But while importing the jobs to the new server, don't forget to change the connection manager (i.e. the new server name), else it will point to the old server and can cause!
Thanks.
April 15, 2012 at 2:51 pm
Thanks I am able to do that, but now i see some of my jobs are failing, i get this error,
Message
Executed as user: ICS\sqlsrvr. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 4:47:54 PM Error: 2012-04-15 16:47:55.28 Code: 0xC00291B1 Source: Delete Empty Files ActiveX Script Task Description: User script threw an exception: "Error Code: 0 Error Source= Microsoft OLE DB Provider for SQL Server Error Description: Could not find stored procedure 'msdb.dbo.xp_sendmail'. Error on Line 43 ". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:47:54 PM Finished: 4:47:55 PM Elapsed: 1.046 seconds. The package execution failed. The step failed.
How can i fix thisissue with Could not find stored procedure 'msdb.dbo.xp_sendmail'.
Urgent assisstance is highly appreciated,
April 15, 2012 at 2:52 pm
Thanks it was great assisstance,
April 15, 2012 at 3:14 pm
what version of SQL are you migrating from?
you should be configuring database mail and using sp_send_dbmail .
---------------------------------------------------------------------
April 15, 2012 at 3:16 pm
I had SQL 2008 and SQL 2008 R2
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply