But how would you go for JOBs migrations ?????

actually new server needs to have cloning of existing server.

Hi ,

actually i give you full scenario

We have a Desktop machine which is currently a sql server 2005 server

with Developer Edition (64-bit) . Now we got a new...

Accidently i installed Wrong SQl server Service Pack

Can some body told me How to remove it ?

Do i need to remoce complete Sql server 2005

it...

Actually ,

currently we have low configuration MAchine

and now we need to clone the databases to High config Machine.

bascially replica of current one to new server .

hi

yes from Different Server.

Following are the different versions

Backup taken from :

Microsoft SQL Server 2005 - 9.00.3310.00 (X64) Edition (64-bit) on Windows NT 5.2 (Build 3790:...

i modified the script and use WITH REPLACE option.

Script used:

Restore database [master]

from disk = 'd:\report_dev\mssql.2\mssql\master_backup_20090602.bak'

with replace

but this time i got new issue of "version mismatch"

Msg 3168, Level 16, State...

Thanks a lot for reply. Query is really gud at least to see update statistics history.

See sometimes what we usually do on servers, we have schedulded the jobs for Update...

What i did :-

Cluster Administrator --> Active Resources --> SQL Server.

Double Click on SQL Server.

Go to Dependencies Tab

It's showing H:,J:,K:,SQL Server Network Name

Now things are ::::::------------

(1)...

still not get ur point, what u want to say.r u talking abt the dependencies option in cluster administrator...where is resource for sql server

Yes it's on cluster. And when i am seeing its active resources in cluster administrator, it's showing H:,J: but not S:.

Please clear "And are the other drives set as...

exactly..i m using same login

thansk a lot

but How do i restore it

can u please provide the restoring script?

i m sorry Gila but i m redirecting u to my new post ..actually i need ur uprgent help

i hope u will understand

below is the link

http://www.sqlservercentral.com/Forums/Topic695572-360-1.aspx

thanks

bhuvnesh

Hi

i build the package then i import it

but Whenever i m executing tha package from Integaration service environment ( "RUN Package)

it working FINE

but whenever i...

Thanks !!!!!!!!

its working fine