Viewing 15 posts - 2,446 through 2,460 (of 2,494 total)
I did this and recovered from it.
If anyone else is thinking of moving Model and MSBD, one important thing is to detach and attach the databases one at a...
March 18, 2004 at 3:14 am
Defragmenting at the logical level is always useful (e.g. rebuild indexes), but fragmentation at the physical level can also be important.
Due to the underlying dynamics of disk head movement, any...
March 18, 2004 at 2:56 am
I should have said 'before writing to the data file it will write ... to the transaction log'.
SQL Server will write updated pages to the data files before the transaction...
March 9, 2004 at 8:58 am
March 9, 2004 at 7:19 am
It may be worth checking th efollowing registry entry to see if it is pointing to your A: drive. (This is unlikely to happen, but could give the same results)
March 9, 2004 at 7:10 am
Does Outlook need to be opened on your other servers. Did this server ever send mail without Outlook opened.
If you look at forum archives you will find a lot of...
March 3, 2004 at 2:52 am
Have you looked in the Maintenance Plan report file. This gives far more diagnostic information than found in the Job History display.
Also, have you tried manually copying a file that...
March 3, 2004 at 2:37 am
You can create Maintenance Plans for MSDE instances using Enterprise Manager, providing you have done some groundwork.
If you have MSDE 2.0 (SQL2K) installed, it helps a lot to be on...
March 2, 2004 at 2:59 am
Most defrag tools will not touch files that are in use. This means that if SQL Server is running, no database files will get defragmented. You will need to stop SQL...
February 24, 2004 at 3:08 am
You are looking at about 185GB just for this table. It is worth reviewing all your space estimates to get bot ha worst-case and a realistic estimate of space required. If...
February 23, 2004 at 4:33 am
Two points...
1) You need to be aware of the internal structure of the transaction log, and what happens when you do a backup and when you do a shrink.
See 'Shrinking...
February 11, 2004 at 3:00 am
MSDE 2000 with SP3a will by default remove all server connectivity. Log on to the box and run the Server Network Utility to enable your favourite protocol. Then stop/start MSDE...
January 28, 2004 at 2:55 am
My advice is:
a) Talk to your production support and security people to see if what you are planning will be allowed to go live. History is littered with applications that...
January 28, 2004 at 2:50 am
Some reasons for storing images in a DB
a) Data integrity. Most applications I have known that use a mix of DB and non-db data storage have had problems with integrity...
January 26, 2004 at 9:51 am
It is important to not confuse reclaiming space within the filesystem with reclaiming space within the database.
SHRINK is used to reclaim space within the file system. After running a SHRINK, your...
January 26, 2004 at 6:53 am
Viewing 15 posts - 2,446 through 2,460 (of 2,494 total)