Viewing 15 posts - 3,586 through 3,600 (of 6,676 total)
You were obviously able to connect to SQL Server - so, I am not sure what the problem you are experiencing is.
If you had to right-click and run as Administrator...
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 10, 2010 at 7:43 pm
Please open a new thread - you'll get many more people looking at your question.
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 9, 2010 at 7:52 pm
cagan (9/9/2010)
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 9, 2010 at 7:36 am
What is recent? Current data, one day - one week?
If you need current data, you have one choice - really. That would be replication - and you already...
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 8, 2010 at 7:01 pm
How long does it currently take to backup?
What is your maintenance window for backups?
The first thing I would look at is buying a third-party backup utility that compresses the backups...
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 8, 2010 at 5:46 pm
Not sure what you mean when you say replication didn't work. That is definitely one of the options for creating a reporting server.
Other options are:
o Database Mirroring (Enterprise Edition...
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 8, 2010 at 5:40 pm
What is the database system that is running on AIX? Most of the database products that will run on AIX will have some type of ODBC/OLEDB access. Once...
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 8, 2010 at 3:06 pm
jerry-621596 (9/8/2010)
It all seems to be working better now. Changed...
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 8, 2010 at 3:01 pm
sanderstad (9/8/2010)
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 8, 2010 at 2:48 pm
Just to be clear - you are not really upgrading an instance of SQL Server. You are installing a new instance and migrating the databases to the new instance.
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 8, 2010 at 2:42 pm
GilaMonster (9/7/2010)
1) - Rebuild indexes, update statistics
2) - Integrity check, backup database
Integrity check before backup. There is no point whatsoever...
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 7, 2010 at 2:14 pm
Again, you will need to upgrade to at least SP3 CU4 or the locked pages in memory option won't be honored. You also have to start SQL Server with...
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 6, 2010 at 7:22 pm
Because you are running Standard Edition on SP2 - you do not have the advantage of using locked pages in memory.
You'll need to set even lower max memory than 16GB...
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 6, 2010 at 7:05 pm
Well, I don't know what to tell you - are you creating those backup files from a different system/instance? Could you be creating those backups with a non-native backup...
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 6, 2010 at 3:10 pm
mak101 (9/6/2010)
How can I open stored package from management studio?
You cannot open SSIS packages in SSMS - you have to use BIDS to open the packages and work with them.
Within...
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 6, 2010 at 12:15 pm
Viewing 15 posts - 3,586 through 3,600 (of 6,676 total)