-
moving jobs to a new server
Hi,
I have to move my SQL server data from win95 to NT.
When it comes to databases I would execute attach option.
When it comes to backup devices I think I could simply copy the folder where
backup devices are being located? IS it true??
How about moving jobs; DTS and Database Maintenance Plans???
Any Ideas??
Thanks,
Andy
-
moving jobs to a new server (reply)
Moving Databases - Detach, Copy file Attach
Backup Devices - Isn't it simple to create
Maintenance Plans - Isn't it simple to create
Jobs - Highlight Jobs , All Task, Script Save Script and applyon to target Server
DTS - Highlight Save as file or save on to target server.
BE CAREFUL ON THE REFERENCE TO THE EXISTING SERVER. THEY HAVE TO BE CHANGED IF YOU ARE NOT GOING TO RUN THE EXISTING SERVER. CHECK ALL STORED PROCEDURES & VIEWS IN YOUR DATABASE EVEN AFTER MIGRATING FOR ANY REFERENCES..
------------
andy at 1/21/01 1:12:13 PM
Hi,
I have to move my SQL server data from win95 to NT.
When it comes to databases I would execute attach option.
When it comes to backup devices I think I could simply copy the folder where
backup devices are being located? IS it true??
How about moving jobs; DTS and Database Maintenance Plans???
Any Ideas??
Thanks,
Andy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|