Viewing 15 posts - 4,066 through 4,080 (of 6,676 total)
To create a new blank database with the full schema I recommend the following:
1) Download and install SQL Compare from Redgate (trial edition is fully functional) and purchasing it 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
March 4, 2010 at 5:21 pm
What you should be doing is:
CASE WHEN Item = 5 THEN (SELECT {column} FROM table WHERE ...)
ELSE 1
END
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
March 4, 2010 at 5:12 pm
Nicholas Cain (3/4/2010)
You can put all of the SQL resources on that one disk (obviously not recommended)...
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
March 4, 2010 at 5:10 pm
As in all things, it depends 😉
Using Netapp as an example, you can present storage from different aggregates to your server and direct access to those different aggregates through different...
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
March 4, 2010 at 5:09 pm
AlreadyPicked (3/4/2010)
Is 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
March 4, 2010 at 7:07 am
Here are a couple of options:
1) Use SSRS - create a report based on the stored procedure. From there, you can export to Excel or even schedule it 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
March 3, 2010 at 3:47 pm
So, you basically removed yourself from sysadmin access because your login is a part of the BUILTIN\Administrators group.
A couple of options:
1) Connect with a known SQL account with sysadmin privileges...
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
March 3, 2010 at 3:39 pm
Yes, you can disable those messages using a trace flag. See this article for further information: http://www.mssqltips.com/tip.asp?tip=1457
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
March 3, 2010 at 3:09 pm
Well, I wouldn't say it was normal either - but I have seen it quite often. Mostly where the company wants to be able to deliver their product on...
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
March 3, 2010 at 10:25 am
Steve Jones - Editor (3/3/2010)
Thanks for the update. That is an interesting behavior, makes me wonder how they are building connection strings in the plans.
Since maintenance plans are really just...
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
March 3, 2010 at 9:49 am
You need to run the following on that database and post the results here:
DBCC CHECKDB({your database}) WITH all_errormsgs, no_infomsgs;
What you posted before does not show the errors and we need...
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
March 3, 2010 at 9:39 am
Check to see if those databases have auto close enabled.
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
March 3, 2010 at 8:51 am
Marcia Q (3/2/2010)
klnsuddu - Take a look at Jeffery's post. Bulk_logged recovery mode doesn't matter with indexing.
To answer your question though - According to BOL...
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
March 2, 2010 at 1:39 pm
You need to talk to the administrator of that system and find out where you can put your backup file so it will be accessible to that system. 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
March 1, 2010 at 7:05 am
Is there a reason you cannot perform a backup/restore? If that cannot be done, download the trial edition of SQL Compare and SQL Data Compare from Redgate. Use...
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
February 28, 2010 at 11:08 am
Viewing 15 posts - 4,066 through 4,080 (of 6,676 total)