Viewing 15 posts - 2,836 through 2,850 (of 6,676 total)
This error indicates an issue with the network while backing up:
995(The I/O operation has been aborted because of either a thread exit or an application request.).
You see this error...
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
July 15, 2012 at 10:03 am
I use CTE's to organize my queries and move derived tables up to the top of the query. In other cases, I will use a CTE to include row_number,...
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
July 15, 2012 at 9:58 am
Check the ANSI_PADDING settings on the database, the column in question and the connection between the 2 different systems.
I am betting you will find a difference between the 2 which...
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
July 14, 2012 at 8:17 am
Update Statistics has an options to update only column based statistics, index based statistics or both. Please refer to BOL for exact syntax.
Note: sp_updatestats will only update statistics that...
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
July 10, 2012 at 12:20 pm
GilaMonster (7/8/2012)
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
July 8, 2012 at 9:43 am
GilaMonster (7/8/2012)
Coming from 2005, probably not. If you'd been coming from SQL 2000 I would have said absolutely yes.
I keep hearing that they have fixed this issue - and still...
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
July 8, 2012 at 9:31 am
I started my career as a computer operator for the Army. Left the Army and went to work as a computer operator and realized I wanted to move 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
July 8, 2012 at 8:50 am
GSquared (7/5/2012)
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
July 5, 2012 at 12:26 pm
AAKR (7/5/2012)
* copy files from server to server it takes more time...
I heard an option with using of Sanpshot replication we can create the database.
any...
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
July 5, 2012 at 12:20 pm
Be aware that the option to purge data after a set time in the agent properties is a one-time manual process.
That is, if you uncheck the option to manage 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
July 4, 2012 at 9:02 am
The question I have is how are you going to use this? If you are using this in a where clause it is most likely a better option 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
July 4, 2012 at 8:31 am
satishthota (6/29/2012)
I need a query without split function
Is the requirement to remove the UDF something that is mandated by company policy? Or, are you looking at the function as...
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
June 29, 2012 at 7:52 am
How are you checking the database size?
If you are right-clicking the database and selecting properties to see the database size, that size includes the size of the transaction log 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
June 26, 2012 at 12:41 pm
You should be able to - but, since it is an Express version I am not sure whether or not it will work. If it does work, it will...
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
June 25, 2012 at 3:41 pm
I would think that DPM has a console that lists all of the servers and schedules that it uses. At least, that was my understanding...
For RedGate and others like...
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
June 25, 2012 at 2:18 pm
Viewing 15 posts - 2,836 through 2,850 (of 6,676 total)