Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
garrydawkins
Starting Member
4 Posts |
 Posted - 2004-05-20 : 15:57:42
|
I got a server that Crashed. My network group was able to get it up and running but it's vary fragile. One of the disk is done. What's the best way to get the my database:tables,views,stored procedured,dts packages, jobs off the bad server without crashing it again? I used the databae copy utility but found out that some of the database are replicated and it wont allow it to copy. ThanksJust another day in the life of a dba GDawkins |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-20 : 16:16:56
|
| Copy the MDF and LDF files to another location. Copy the .BAK files also.Tara |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-20 : 16:42:59
|
| If it's dubious the take backups and copy the files and restore.DTS packages will probably be in msdb - you can just copy sysdtspackages or the database. Consider holding dts packages in a directory rather than msdb.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Server Crashing with Mutiple database