Viewing 15 posts - 2,371 through 2,385 (of 2,473 total)
If you use SQLBackTrack backup/recovery software from BMC, this can be done. With standard SQL Server backup/recovery the answer is no.
September 22, 2004 at 4:42 am
Apart from anything else, your clause '@LearnID IN (puTOP_SECTIONID)' is the wrong way round. The IN clause works like 'needle IN haystack'. Try rewriting it as 'puTOP_SECTIONID IN...
September 22, 2004 at 4:37 am
To get PSS support, phone your local Microsoft office. If that is not the right number they will give it to you. When you get to PSS, you will either...
September 16, 2004 at 7:03 am
If you use W2003, you do not have any choice about using MDAC 2.8 - it is the version shipped with W2003.
September 16, 2004 at 3:11 am
I would echo Chris's advice. You should contact PSS regardless of anything else you do.
It may also be worth looking at your autogrow parameters. Try to work out the likely...
September 16, 2004 at 3:06 am
As with all debugging, the most likely thing is that the error message is telling you the truth. The most likely cause is that one of the file paths used...
September 10, 2004 at 3:11 am
As some people have already said, you need to do transaction log backups to save your log information. Do not use the truncate_only option unless you really want to loose...
September 10, 2004 at 2:58 am
Our standard is to use NT authentication everywhere we can. This is mainly because NT auth gives improved security over SQL auth.
All but 1 of our production instances only...
September 10, 2004 at 2:48 am
If you did not have a logging mechanism, you would not have a rollback mechanism.
If your logging mechanism was limited to the memory on your box, you would be limited...
September 10, 2004 at 2:23 am
You may need to think more about the impact of shrinking log files that will grow again over the next few days.
Any shrink operation will release disk space to the...
September 8, 2004 at 3:37 am
How is this any different to using SQL Server authentication?
September 6, 2004 at 3:11 am
The only reliable way to retrieve a random sample of records wit SQL Server is to use the Newid() function. Do a search of this forum's archives for 'random' and...
September 2, 2004 at 7:39 am
There is no way to ensure you have a relationally intact set of data by taking a backup. This is because applications can continue to update the databases while the...
September 2, 2004 at 6:03 am
SQL Mail is not the most bug-free product that Microsoft have produced. Even though it can work for weeks without trouble, it is not unusual for mail to stop working...
September 2, 2004 at 5:45 am
If you can get a RAM disk set up, you could put the log file on there. If you do this, you may need to reduce the checkpoint interval so...
August 25, 2004 at 2:58 am
Viewing 15 posts - 2,371 through 2,385 (of 2,473 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy