Viewing 15 posts - 3,616 through 3,630 (of 6,676 total)
That is normal behavior - a differential backup can only be restored after the full backup that was taken right before it. The differential backup is tied to 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
September 3, 2010 at 5:21 pm
Ram:) (9/3/2010)
When users reported me that they are getting timeout expire error and few applications are getting slow, I checked and found the log...
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
September 3, 2010 at 5:09 pm
In your maintenance plan, how are the two tasks connected?
And, verify that you have configured the maintenance cleanup task with the correct directory and extension. As was previously mentioned...
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
September 3, 2010 at 5:05 pm
There are three types of backups available in SQL Server - and they all work in relationship with each other.
First, you have a full backup - which is required 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
September 2, 2010 at 2:33 pm
Make sure the version of the client tools is at the same or greater version as the database you are connecting to. For that matter, make sure the 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
September 2, 2010 at 2:13 pm
I see no benefit to installing SQL Server binaries to another drive. When I install SQL Server, I take the default location for the program files and put 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
September 1, 2010 at 6:19 pm
Well - that says a lot. The GUI is buggy - has been since Enterprise Manager and should be avoided.
I would recommend scripting your changes and running them 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
August 31, 2010 at 8:10 pm
free_mascot (8/30/2010)
For that you do have two option:
1. Kill the connection to the respective database
2. In...
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 31, 2010 at 8:08 pm
EasyBoy (8/31/2010)
Jeffrey Williams-493691 (8/30/2010)
Databases...
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 31, 2010 at 8:05 pm
How are you inserting this data? Are you using the GUI tool to insert the data, or are you using a query window and issuing insert statements?
Check the SQL...
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 30, 2010 at 2:33 pm
Why are you shrinking databases? This should not be an automated process, or something that is done on a regular basis - even if not automated.
Databases will grow -...
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 30, 2010 at 2:29 pm
First, why do you need to do this? It doesn't make sense to have created tables with IDENTITY and then disable it to insert data. The whole purpose...
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 30, 2010 at 2:13 pm
You are not going to like the answer - but, using Enterprise Manager to open a table and edit it is the problem. That GUI is broken, 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 29, 2010 at 2:10 pm
You do that in the report itself. There is an option on the column properties to suprress duplicates which is what you are looking for.
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 29, 2010 at 2:03 pm
Steve Jones - Editor (8/29/2010)
Polyserve is the only software I'm aware of that's like this.
That is the only one I know of that was specifically designed for SQL 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
August 29, 2010 at 10:43 am
Viewing 15 posts - 3,616 through 3,630 (of 6,676 total)