Tuesday, March 27, 2012

Changing The Physical Server

Hi,
I have Production Database on one server which shares the space with
many other databases. Now I am planning to shift the database to
another (separate) physical server.
As long as data and logins are concerned I can transfer it to the
new database server. But I also have many of the critical scheduled
Jobs and DTS packages on the existing server. Is there any way through
which I can get these DTS packages and Jobs on the new server?
regards
Rohit
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Server-Chang...ict250272.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=866311
DTS packages -- Open the package, Menu Package --> Save as... 1. to a new
server, or 2. structured storage file, import the file in the new server
Jobs -- Right click on the job, Generate SQL Script...
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Rohit" wrote:

> Hi,
> I have Production Database on one server which shares the space with
> many other databases. Now I am planning to shift the database to
> another (separate) physical server.
> As long as data and logins are concerned I can transfer it to the
> new database server. But I also have many of the critical scheduled
> Jobs and DTS packages on the existing server. Is there any way through
> which I can get these DTS packages and Jobs on the new server?
> regards
> Rohit
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/Server-Chang...ict250272.html
> Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=866311
>
|||Hi
You may want to look at using:
http://www.sqldts.com/default.aspx?242
Also check out:
http://support.microsoft.com/default...;en-us;Q314546
John
"Rohit" wrote:

> Hi,
> I have Production Database on one server which shares the space with
> many other databases. Now I am planning to shift the database to
> another (separate) physical server.
> As long as data and logins are concerned I can transfer it to the
> new database server. But I also have many of the critical scheduled
> Jobs and DTS packages on the existing server. Is there any way through
> which I can get these DTS packages and Jobs on the new server?
> regards
> Rohit
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/Server-Chang...ict250272.html
> Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=866311
>
sql

No comments:

Post a Comment