Viewing 15 posts - 16 through 30 (of 32 total)
Earlier I mentioned log truncation. A full backup does this - not me. I was just thinking out loud at what all happens....
I have the latest builds on both boxes. ...
October 28, 2005 at 2:45 pm
So what I am hearing, and PLEASE correct me if I am wrong, is this:
If I am to the point where I can restore last nights full backups (meaning my...
October 28, 2005 at 10:47 am
Dont forget you can restore from the QA using something like:
restore database JUNKNAME from disk="c:\righthere\junk.bak'
See BOL for more on Restore.
It is worth a shot to see if it bombs out...
October 28, 2005 at 10:24 am
At the point of sounding presumptuous, I'll restate the above reply in more frank terms.
FIX your jobs that are running during that time, like...
October 28, 2005 at 9:55 am
This is not something I wanted to admit. Being the first week on a new job, I had rather take the blame for something I may have done than suspect...
October 19, 2005 at 7:43 am
The logs show nothing. The closest thing I can come to an answer is probably my fault. I stopped a backup of Master midstream, then redirected the backup to a...
October 18, 2005 at 7:38 am
Yes, detached and not dropped. They were reattached without incident but the question still remains has anyone ever seen something cause a detachment that appeared to be rather spontaneous?
Studdy
October 17, 2005 at 1:33 pm
PDF files are 7-bit ASCII textfiles. They can be opened in any editor or wordprocessor like Microsoft Word or Wordpad unless the text has been compressed.
Every line in a...
October 12, 2005 at 8:06 am
Never think that memory "thrown at it" will solve all performance related issues...as a general rule, the more - the better - but performance is a broad brush that paints...
October 6, 2005 at 11:40 pm
Does anyone really believe media or hardware that is used now will even be functional in 7 years?
The thing is, about at 2 to 3 years, you need to set...
September 14, 2005 at 7:46 am
Service Pack 3 for SQL 2000.
Wondering if I need to lower the parallel query processing time from the default of 5 to about 2?
September 7, 2005 at 11:01 am
Direct them to Microsoft's TechNet site and it will explain about the minimal overhead - which is primarily display related.
Of course, if you are storing large amounts of Profiler data,...
August 31, 2005 at 7:29 am
If you prefer GUI's (and I do) AND the file to import is not one HUGE S.O.B. (because bcp is probably a smidgeon faster) then the easy thing to do...
August 25, 2005 at 7:29 am
Database id will do it. I just checked, and thanks.
Studdy
August 23, 2005 at 10:05 am
Can't you change it to the ansi charachter that it represents?
Like Chr(143) or similar?
August 23, 2005 at 8:44 am
Viewing 15 posts - 16 through 30 (of 32 total)