Viewing 15 posts - 2,761 through 2,775 (of 2,903 total)
You say you are installing SQL Server 2000 Standard Edition and in other post you stated you are installing it on a Windows 2000 box. Standard Edition MUST be installed...
April 14, 2003 at 8:22 am
Not yet....I wanted to see if I could find out what CAUSED the problem first. I think I may have figured it out. I was loading a third-party tool that...
April 11, 2003 at 11:25 am
Did you do a FULL BACKUP first? How big is your LOG file?
-SQLBill
April 10, 2003 at 5:44 am
Have you used Enterprise Manager and looked at the processes to see if you can identify the one that is locking your database? If you can find that one, you...
April 9, 2003 at 11:06 am
SQL Server DOES NOT store datetime as 2003-04-09 13:29:51 or any other format. It stores it as a number of seconds after a specific date. Refer to the Books OnLine.
Okay,...
April 9, 2003 at 10:57 am
Here's a graphic explanation:
Col1 Col2
A A
A B
B A
B ...
April 2, 2003 at 10:56 am
SQL Server includes several tools; Enterprise Mangager and Query Analyzer are just two of them. Setting the language in SQL Server doesn't change how the datetime is stored, but it...
March 28, 2003 at 6:33 am
What kind of device? Tape or hard drive?
Tape: erase the tape.
Hard Drive: delete the file.
-SQLBill
March 27, 2003 at 6:34 am
Yes, model isn't as important, but MASTER and MSDB need to be backed up. I do them once a month.
MASTER changes when there are users added, changes to schemas, etc....
March 27, 2003 at 6:28 am
Dig,
We were all beginners at one time. I'm not an ASP user, so I can't tell you where the problem is exactly. But I can help you a bit.
Here's the...
March 26, 2003 at 6:23 am
If the last job was done with NO RECOVERY then the LOADING means that it is still waiting for the rest of the restore data. It's not really restoring right...
March 25, 2003 at 12:56 pm
Couple more questions... have you tried running the jobs at any other time of the day?
Have you tried running each step individually?
Can you create some new jobs for a test?...
March 25, 2003 at 12:49 pm
When you see the 'Executing Step 1', have you ever 'Refresh'ed the jobs? (right click on the job or on JOBS in the drill-down tree) and select refresh.)
Has anything changed...
March 25, 2003 at 12:46 pm
You haven't answered the important question that Hanslindgren asked of you...what are you using to get the information? In other words, when you get the response "31/12/aaaa" where do you...
March 25, 2003 at 12:39 pm
This could be an easy one. A differential backup is a backup of ALL of the changes since the last FULL backup. So, your Monday differential (diff) backup is of...
March 20, 2003 at 7:49 am
Viewing 15 posts - 2,761 through 2,775 (of 2,903 total)