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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-07-14 : 10:53:52
|
| Hi,What's the best way to do this?There are two sql 2k servers. Server1, Server2Server1 is running out of space.Server2 has plenty space.In server1 I am only interested on one database.My program is putting data into a table which as a result is causing the server to run out of space.As mentioned, server2 has plenty space.What should I do to free up spaces on server1 so that more data can be uploaded. At the same time may be it is best to put the data from server1 to server2 as soon as it becomes nearly full.Should use the sp_detach and detach ?P.S. What is happening with CTC? ;-)Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-14 : 11:28:31
|
| How big are the hard drives?What are you doing with all the data?Are you sure you're not doing maintenance and not cleaning up the dumps?Brett8-) |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-14 : 13:39:59
|
| Here's a a few questions we always ask on here, over and over and over and over. :) 1. Do you do transaction log backups liek Brett said? If you don't know, the answer is probably no.2. What is your recovery mode set to? If the answer to 1. is no, then it should be set to simple.--You can find the answer to this by right-clicking on database, going to properties, and looking at recovery mode.On your space issue, why don't you just put the data into server2 in the first place?Should use the sp_detach and detach ?--This wouldn't accomplish anything. What would there be to detach. Assuming you mean detach and attach, then you wouldn't have a database on server1 at all anymore. It's probably better to write a script that runs at night. It can copy the data over, and clean up server1 if you really need to be doing this for some crazy reason.CTC? cause this condition? crippling, terrifying concussion? c#$@ t!@#$! c#!=&@! ???MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
db