Viewing 15 posts - 4,711 through 4,725 (of 6,676 total)
Why is your upgrade failing? I am going to guess that it is because you are getting an error. :w00t:
If you wouldn't mind posting the error you are...
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 11, 2009 at 8:23 pm
From cluster admin - find the group that has SQL Server as a resource. It will be the group that also has the R: drive as a resource.
Add all...
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 11, 2009 at 6:05 pm
The SQL Server resource needs to be dependent upon the drive resources so that SQL Server can 'see' them. If the drives are not resources in the same resource...
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 11, 2009 at 5:54 pm
bpowers (8/11/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 11, 2009 at 5:15 pm
SQL Server Maintenance Plans - schedule using SQL Server Agent
SQL Server Integration Services - schedule through Windows Task Scheduler or SQL Server Agent
SQL Server Agent Jobs
Windows Task Scheduler with 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
August 10, 2009 at 11:20 pm
You can alter the database from full recovery model to bulk-logged during the index rebuilds. That will cause the rebuild operation itself to be a minimally logged operation. ...
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 10, 2009 at 11:14 pm
ouqiwu (8/10/2009)
We like to upgrade our database from SQL server 2000 to 2008.
I used named instance, name EOS50, for SQL server 2008 instance. But this solution requests to add EOS50/...
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 10, 2009 at 7:46 pm
Thanks for the links - not sure where in there it talks about side-by-side installation, but I will review it in more detail when I have some time.
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 10, 2009 at 7:09 pm
JC (8/10/2009)
i wil llook at this scenario you suggested
I have already written my plans in SSMS though
I did some testing the last time with BIDS and I had all...
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 10, 2009 at 4:57 pm
What part of the SQL Statement are you trying to use a variable for? SQL has certain limitations on where a variable assignment can be used and if 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 10, 2009 at 1:35 pm
The only compelling reason I can think of is the fact that SP3 is a rollup of the changes and fixes made since SP2. That includes the cumulative updates...
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 10, 2009 at 1:34 pm
Here is what I do:
Create SSIS package in BIDS
Import Maintenance Plans into new project
Save
Now, if I need to reinstall - or even install on a new server - all I...
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 10, 2009 at 1:28 pm
K. Brian Kelley (8/10/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 10, 2009 at 12:57 pm
Well, there's the real problem with striping backups across the network. If one fails, the whole thing is no good anyways.
If this was my system I would be taking...
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 10, 2009 at 9:59 am
You are going to have to tell us what problem you are actually having with backing up across the network. How have you determined that backing up 10-15GB 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
August 9, 2009 at 7:19 pm
Viewing 15 posts - 4,711 through 4,725 (of 6,676 total)