Viewing 15 posts - 5,071 through 5,085 (of 6,676 total)
This is happening because you are backing up across the network and there is a blip on the network. The ideal solution is to backup locally and copy 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
May 30, 2009 at 1:55 pm
I have seen something similar before - where using a login with sysadmin privileges bypasses certain checks and error messages.
This is just one of the many reason why it is...
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
May 30, 2009 at 1:50 pm
Is the server the database is setup on dedicated to SQL Server?
Did you set the lock pages in memory option?
Did you set the max memory appropriately?
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
May 30, 2009 at 1:48 pm
MCHPIS (5/29/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
May 29, 2009 at 9:31 pm
I'm sorry - but I still don't get it.
On the client, we are running Windows XP SP2 Professional (x86). The client machine knows nothing about x64, doesn't know anything...
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
May 29, 2009 at 5:14 pm
Gift Peddie (5/29/2009)
.... on occasion there is an ambiguous error, at other times the application simply dies on the local workstation
The above is the reason for my statement and 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
May 29, 2009 at 4:36 pm
You are welcome - let use know if there is any additional help you 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
May 29, 2009 at 9:22 am
Glad I could help and you are now able to get this to complete.
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
May 29, 2009 at 9:20 am
You are welcome, I am happy I was able to help.
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
May 29, 2009 at 9:18 am
You've got to be kidding, right?
failed with the following error: "Online index operation cannot be performed for index 'PK__DTA_input__009508B4' because the index contains column 'TuningOptions' of data type text, ntext,...
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
May 28, 2009 at 8:53 pm
Column statistics are not updated during and index rebuild. Index statistics are updated for the index being rebuilt.
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
May 28, 2009 at 4:51 pm
PaulB (5/28/2009)
Here is how you do it.
1- Pre-create the database in your "target" server -so you make all decisions about storage.
2- Force-restore over the pre-created database -so datafiles go 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
May 28, 2009 at 4:26 pm
What you could be seeing is two different cached plans based upon different connection options. I would verify that the connection options in SSMS match the connection options from...
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
May 28, 2009 at 4:16 pm
I am not sure if this can be done with Litespeed, haven't tried it myself. I don't know if that option is available.
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
May 28, 2009 at 4:12 pm
Don't forget sp_help_revlogin - if you need to create the logins on a new server.
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
May 28, 2009 at 4:09 pm
Viewing 15 posts - 5,071 through 5,085 (of 6,676 total)