Viewing 15 posts - 4,726 through 4,740 (of 6,676 total)
I am not real sure I understand your problem - or in fact, what your question really is. I can, however, tell you that I currently backup a 450GB...
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 9, 2009 at 4:16 pm
Yes, it is possible - and you have basically the same issues that you would with multiple instances on a single machine. Namely, you need to make sure 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 9, 2009 at 4:06 pm
I just took a quick glance at your reports. You have a high percentage of parallelism waits - in fact, that is the highest waits you have on this...
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 9, 2009 at 11:56 am
To run an SSIS package - you have to have Integration Services installed. Doesn't matter about BIDS or SQL Server, but you do need to have Integration Services -...
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 8, 2009 at 9:56 pm
What are the actual date/times of the files - what time did the task start?
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 7, 2009 at 2:15 pm
Warren Peace (8/7/2009)
lol, why the hell does MS leave 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 7, 2009 at 12:36 pm
Warren Peace (8/6/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 6, 2009 at 7:36 pm
Because you installed x64 - all you really need to do is set the max memory for SQL Server. Since you installed the standard edition, you probably should not...
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 6, 2009 at 5:18 pm
Is it the data file or the log file that is growing? If you find that the log file is growing - you need to identify the process 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
August 6, 2009 at 4:15 pm
Right-click on the maintenance plan under the maintenance folder and select View History. That will show you how long each task takes.
Now, if you are executing the task 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 6, 2009 at 4:09 pm
That error message is stating that it could not open the backup file, not the database file. That can be caused be several things, for example it could 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
August 6, 2009 at 4:08 pm
Yes, there are quite a few known issues that you could run into. I would recommend running the Upgrade Advisor on your 2000 database before attempting to upgrade.
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 6, 2009 at 2:20 pm
A couple of things to check:
1) Did you perform a full backup, or was it a transaction log or differential backup? Either of those will be a lot smaller...
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 6, 2009 at 2:18 pm
Jeff Moden (8/6/2009)
GilaMonster (8/6/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 6, 2009 at 2:09 pm
Let's say you have the following tasks in your maintenance plan:
Check Database Integrity
Backup Databases
Maintenance Cleanup
And now, let's say that normally the integrity check takes 1 minute and the backup takes...
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 6, 2009 at 1:47 pm
Viewing 15 posts - 4,726 through 4,740 (of 6,676 total)