Viewing 15 posts - 1,036 through 1,050 (of 1,319 total)
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...
-- You can't be late until you show up.
July 11, 2008 at 8:29 am
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...
-- You can't be late until you show up.
July 11, 2008 at 8:22 am
GSquared (7/11/2008)
Are the database files full? That might allow deletes but not inserts.
Good point. I didn't think about that - it's still early and my brain isn't fully functional...
-- You can't be late until you show up.
July 11, 2008 at 7:34 am
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...
-- You can't be late until you show up.
July 11, 2008 at 7:09 am
EdVassie (7/11/2008)
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...
-- You can't be late until you show up.
July 11, 2008 at 7:02 am
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...
-- You can't be late until you show up.
July 11, 2008 at 6:52 am
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...
-- You can't be late until you show up.
July 11, 2008 at 6:43 am
What are you importing from? A flat file, a table from another database? From another server? Need more detail to truly be of help.
-- You can't be late until you show up.
July 10, 2008 at 6:54 am
BAD-DBA-DAB (7/10/2008)
Hi,backup & restore is the best way to move databases from one box to another. Copying mdf & ldf is a bad practice.
I don't neccessarily agree with that statement....
-- You can't be late until you show up.
July 10, 2008 at 6:51 am
george sibbald (7/10/2008)
-- You can't be late until you show up.
July 10, 2008 at 6:07 am
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...
-- You can't be late until you show up.
July 9, 2008 at 6:34 am
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...
-- You can't be late until you show up.
July 9, 2008 at 6:16 am
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...
-- You can't be late until you show up.
July 9, 2008 at 6:08 am
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...
-- You can't be late until you show up.
July 7, 2008 at 1:13 pm
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...
-- You can't be late until you show up.
July 2, 2008 at 6:28 am
Viewing 15 posts - 1,036 through 1,050 (of 1,319 total)