Viewing 15 posts - 4,621 through 4,635 (of 6,676 total)
Google parameter sniffing - sounds like that might be what you are running into.
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
August 26, 2009 at 7:42 pm
As everyone else has said - you need to check with your vendor. Also, check with your management and find out if you have purchased software assurance - and...
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
August 26, 2009 at 7:40 pm
What's the result from DBCC LOGINFO? Are the active virtual log files (status = 2) at the end of the files?
I think the first thing you need to do...
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
August 26, 2009 at 7:36 pm
CirquedeSQLeil (8/25/2009)
I prefer to separate SSIS off onto it's own server - we call them...
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
August 25, 2009 at 8:34 pm
I am in the process of implementing a four-node PolyServe cluster. What I have found is that the installation in PolyServe is not the same as MSCS clustering installation....
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
August 25, 2009 at 8:25 pm
Jeff Moden (8/25/2009)
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
August 25, 2009 at 8:17 pm
Not 'create a new database', but 'create a new blank database'. That is, a database with nothing in it at all.
When you perform the comparison between your existing database...
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
August 25, 2009 at 5:42 pm
Get a comparison tool (Redgate SQL Compare, ApexSQL, etc...).
Create a new blank database and perform a schema comparison between your existing database and the new blank database. Save the...
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
August 25, 2009 at 4:54 pm
Lynn Pettis (8/25/2009)
cjohn5552 (8/25/2009)
Hahaha, that's funny. No wonder I was having trouble finding documentation for those "keywords". Sorry for the misunderstanding.
No problem, it's why we are here, to help clear...
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
August 25, 2009 at 3:34 pm
The only way to remove those files is to move the objects in those filegroups to the other filegroup. Drop and recreating the indexes on those filegroups should take...
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
August 25, 2009 at 3:02 pm
No - you cannot restore a database with multiple files and reduce the number of files. What you have to do is restore the database with all of the...
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
August 25, 2009 at 1:38 pm
Not sure why this would be a maintenance nightmare, you have to add those users somewhere so they can be managed. Normally, that would be done through AD and...
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
August 24, 2009 at 9:47 pm
I am going to guess that the recovery model of the database is full - and that you don't have regular scheduled transaction log backups.
If that is the case, you...
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
August 24, 2009 at 9:36 pm
I've been running several systems in production for several years now, and we have not had any problems. Of course, we do not have any issues with accessing other...
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
August 24, 2009 at 9:32 pm
willian (8/24/2009)
SELECT A.NOME,
A.MATRICULA,
CASE P.TIPO_AULA
...
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
August 24, 2009 at 2:25 pm
Viewing 15 posts - 4,621 through 4,635 (of 6,676 total)