Viewing 15 posts - 5,731 through 5,745 (of 6,676 total)
The only tools I know of are the standard OS tools (Disk Management) and specific SAN tools (e.g. SnapDrive for Netapp).
Basically, your SAN presents a volume to the OS. ...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 2, 2009 at 9:46 am
What version of SQL Server 2000 are you trying to install?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 1, 2009 at 2:22 pm
With a database that is less than 1GB in size, performing differentials every 15 minutes shouldn't take a long time at all. How large these backups are going to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 1, 2009 at 11:55 am
Database is so big, there are many unused backup tables in database, so I delete them and reduce Database size to easy manage. That's why I want to shrink
As your...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 1, 2009 at 11:38 am
What is the datatype of the TotalTime column? If it is not a numeric datatype - it is not going to sort the way you think it will.
You would...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 1, 2009 at 11:18 am
If you really need a column to show the length, don't store this data and try to keep it updated all the time. Create a computed column or create...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 31, 2008 at 12:18 pm
Yes - I think it is possible that is the issue. However, just because one volume is not having an issue does not mean another volume isn't.
You would need...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 31, 2008 at 12:03 pm
Two things I can think of:
1) Is the volume this database resides on NTFS - or, something else? What kind of SAN is presenting this storage - check with...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 31, 2008 at 11:29 am
With lock pages in memory, you definitely need to drop the max memory down to no more than 14GB. Leaving the OS only 1GB of memory will not be...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 31, 2008 at 11:07 am
Yes, I was referring to users and applications. If you create a Person table - with a LastName column and declare it as VARCHAR(8000), then you will get a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 31, 2008 at 10:03 am
Can you run SELECT @@VERSION and find out what version you have?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 31, 2008 at 9:47 am
What version are you running? There was a version released that had this bug - and you are going to need to upgrade to solve the problem.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 30, 2008 at 7:49 pm
klini (12/30/2008)
I've meticulously tried to get my varchars to match what I expect the data to look like. I'll now just set everything to 8000 and save myself a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 30, 2008 at 7:43 pm
The first thing you need to do is run an integrity check on that database - just as the message is telling you (sorry, but I have to wonder if...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 30, 2008 at 7:38 pm
SELECT ...
,CASE WHEN COALESCE(Memo, '') = ''
THEN 'NO'
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 30, 2008 at 3:41 pm
Viewing 15 posts - 5,731 through 5,745 (of 6,676 total)