Viewing 15 posts - 46 through 60 (of 104 total)
Greg, thanks for your reply. I looked the KB article it says is fixed in SP4 but I already have SP4 installed and it's still having this error.
July 22, 2005 at 11:21 am
Thanks for the reply. Yes. I'm sure the job ended. Fortunately, it was just one incidence. I'll keep my eyes on it. Thanks again.
July 1, 2005 at 11:01 am
According to the dump, the error is happening during backup. Does it also happens when backup is not running ?
June 30, 2005 at 1:23 pm
The error is very simimilar to the decription in KB 330307. Please take a look, and the error occurs prior to SQL 2000 SP3. What version are you running ?
June 30, 2005 at 1:13 pm
Thank you so much !
June 29, 2005 at 7:55 pm
No. You don't need to restart the server. However, I will not add the file when there are users performing changes. I would recommend do this at non-business hours.
Also, it...
June 14, 2005 at 12:51 pm
Also make sure the login has the permission/rights to the desired database.
June 14, 2005 at 12:35 pm
I haven't done this before, but Brian Knight's book "Admin 911 SQL Server 2000" recommends the following steps:
(1) Check the hardware installtion requirements
(2) Install SQL Server 6.5 SP4
(3) Make sure...
June 14, 2005 at 12:29 pm
Another way to do this is to use DTS. Essentially, in the dts, you need to import the excel file into a temp table. Then use the SQL Task to...
June 14, 2005 at 12:20 pm
You can use system function STATS_DATE(table_id, index_id) to return the date when index was last updated.
April 28, 2005 at 10:11 am
make sure the account that starts the SQLSERVERAGENT service has access to \\epen?\bac\user
April 28, 2005 at 9:56 am
Your boss is right that RAID1 cannot be hotswapped unless is hardware implemented. Economically speaking, your boss is also correct to make one single RAID5 because RAID1 is very expensive in that...
April 28, 2005 at 9:50 am
Take a look at:
(1) right click the database and select "Transaction Log" tab. Then check if "Restrict file growth" is selected. If so, that means you need to expand the...
April 28, 2005 at 9:20 am
Is it slow only when you do the join between local and remote server ? try not to join a remote table when it is too big. You could DTS the...
March 29, 2005 at 9:37 am
I use Transact-SQL to do the backup so that I have more control. For example, if I have two databases to backup, then my step1 is to delete the old...
March 29, 2005 at 9:15 am
Viewing 15 posts - 46 through 60 (of 104 total)