Gail also has a good blog about shrinking as well (which in turn, also references Paul's). Check it out here: http://sqlinthewild.co.za/

In addition, truncating/shrinking the logs are not as big an...

Actually I've googled lakh and knew what it meant. It's become fairly common on the web boards and, as our world grows smaller due to the internet, we should try...

Good point. I didn't think about that - it's still early and my brain isn't fully functional...

As Jeffrey stated, there is an "append" available but it comes with a potential cost. If inserting from DB2 to DB1, can you accept potential duplicates in the tables? Can...

EdVassie (7/11/2008)

---

sql.sanya,

What benefit is the server giving to your business? If it is helping the business earn money, then the business needs to pay money to keeps its assets...

As your database seems to be in Full or Bulk-Logged mode, you should be backing up the transaction log with some regularity. That'll stop it from filling up and halting...

How much memory is on the server? How much is allocated to SQL? SQL grabs the allocated memory on startup and keeps it. It won't release it. How big...

What are you importing from? A flat file, a table from another database? From another server? Need more detail to truly be of help.

I don't neccessarily agree with that statement....

george sibbald (7/10/2008)

---

well, looks like a done deal, so good luck. If you get performance problems make sure vmware admin is involved as well and its not just dumped on...

Really not much to it. What we've done is shutdown the original SQL server services and COPIED the mdf and ldf files to the new location then simply used sp_attachdb...

Just to expand a little on Gail's response. RedGate's tool helped tremendously with an issue I was having. SQL log rescue IS now a free download, only for SQL2000. It...

As far as moving jobs, if you backup/restore your original msdb, you won't have to recreate any jobs, simply delete the ones that are no longer necessary. You will have...

I've used both Litespeed and SQLSafe. Very good products, great compression, speed vs. native and encryption. I've read about Hyperbac and currently use Veritas NetBackup. The jury is still out...

Shekhar, this really should have gone under data corruption as you'll likely get quicker responses as to what may have led to the corruption. Do you have a good backup...