Viewing 15 posts - 1,306 through 1,320 (of 2,904 total)
Here is a BIG problem:
quote: We got mulitple people working on the development. each with their on copy of DB.
Why do they each have their own copy of the DB?...
January 19, 2006 at 7:30 am
BTW-David and I answered two different parts of your question.
1. Yes you can attach .mdf and .ldf files if you have not detached them (either using sp_detach or Enterprise Manager)....
January 19, 2006 at 7:21 am
No. If your databases were online when you made copies of the .mdf and .ldf files, they won't be usable. To be able to copy the .mdf and...
January 19, 2006 at 7:19 am
I can't see how it was working two days ago ('2005-15-12') as that date doesn't exist. I would be more willing to believe that it quit working after '2005-12-12'...
January 18, 2006 at 12:00 pm
BTW-the bulk inserts are done every 5 seconds.
-SQLBill
January 18, 2006 at 11:53 am
I have a 14 disk SAN array and do both bulk inserts and reads. The SAN was partitioned into separate RAID partitions and I have my user databases on...
January 18, 2006 at 11:53 am
Update your SQL Server to at least SP3a.
-SQLBill
January 17, 2006 at 10:42 am
I wouldn't do tlog backups every 5-10 minutes, that can be overkill. But do them more frequently....I do mine every four hours and my tlog never grows very large EXCEPT...
January 17, 2006 at 10:38 am
A reindex is an offline action. That means the database pretty much can't be used. I prefer DBCC INDEXDEFRAG which is online and rarely (for me) affects my users.
Also,...
January 13, 2006 at 12:07 pm
I'm agreeing with JP de Jong about the tlog. I re-read your post and noticed you never backup the tlog. Do this at least once a day (I suggest...
January 13, 2006 at 12:03 pm
Before you do this, scare the decison makers. Type up a formal letter stating you are willing to do this and will accomplish it to the best of your ability....
January 13, 2006 at 11:58 am
Maybe we are misunderstanding you and making this harder than it has to be....do you want to permanently change the values or just adjust for them in a script?
To permanently...
January 13, 2006 at 11:50 am
I would suggest that you consider doing more frequent differential backups. Maybe once or twice a day. When you do restores, a differential can really cut down the amount of...
January 13, 2006 at 11:44 am
Also, how do you enter those orders? Are they done all at once (Bulk insert)?
-sQLBill
January 13, 2006 at 7:30 am
Viewing 15 posts - 1,306 through 1,320 (of 2,904 total)