Viewing 15 posts - 2,416 through 2,430 (of 2,494 total)
It is not SQL that is taking the lock, it is the tape backup process.
If the success of tape backups is not properly checked, a failed backup may not get detected...
July 9, 2004 at 8:19 am
I have recently tried defragging a W2003 test server running SQL2K SP3a, while SQL was active and using the defrag tool supplied with W2003.
It worked.
Even so, I would not want...
June 30, 2004 at 7:00 am
Jeff,
The key to this has already been posted. The ability to stop/start SQL Agent has nothing whatsoever to do with internal SQL Server authorities. It is purely a NT...
June 29, 2004 at 7:50 am
My experience of Windows Defrag is that it needs the same amount of free space as the largest fragmented file if that file is to be defragmented.
You get a warning...
June 28, 2004 at 2:30 am
If your clients are on a WAN, ensure that the port used by the named instance is not blocked by firewalls. Firewall blocking may not inhibit registration, but it would...
June 24, 2004 at 3:13 am
Are there any cirsumstances where 2 GUIDS could be created with the same value?
If one of the factors in GUID creation is time, then the granularity of the time factor...
June 24, 2004 at 3:04 am
There is a problem on SQL2000 SP3 documented in KB815115 A DTS Package That Uses Global Variables Ignores Error Message Raised by RAISERROR. A fix is available on...
June 18, 2004 at 3:30 am
If you are talking about how to prevent SQL System Administrators from access databases, you can NOT do this. Some other DBMSs allow access by system admins to be prevented,...
June 7, 2004 at 6:02 am
I will have a go at some of the questions...
a) You should always go for a 3NF design at the logical design stage. Until you have a 3NF design, you...
May 13, 2004 at 4:28 am
In most organisations, MCDBA is unlikely to improve your salary or career path on its own. You need to show by your actions you are worth paying more.
In job hunting,...
May 13, 2004 at 4:12 am
Why are you not using NT only security. We do this on all our servers bar 1. The odd one is running some legacy web-based applications that require SQL authentication.
NT...
May 13, 2004 at 4:05 am
I completely agree with Brian.
There are a number of issues here...
1) Comparisom with other vendor's release stategy.
My main experience is with DB2. When IBM are near to making a new...
April 29, 2004 at 4:04 am
I would set the database offline. Even a single user connected would stop the DETACH working.
April 23, 2004 at 5:06 am
Use the same process as you would on a normal SQL Server database.
Connect to the MSDE instance in Enterprise Manager, right-click and select Properties, then set the required memory on...
April 23, 2004 at 4:57 am
Viewing 15 posts - 2,416 through 2,430 (of 2,494 total)