Viewing 15 posts - 4,141 through 4,155 (of 6,676 total)
Yes, you continue and it will only uninstall the instance and components that you have selected.
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 12, 2010 at 10:16 am
Take a look at using SQLCMD mode instead - where you can then use a variable for the database name. You can review this article to see how 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
February 12, 2010 at 7:37 am
Yes - I missed that...sorry, you do need a column that is going to be unique to build the indexed view.
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 12, 2010 at 7:18 am
There is nothing that states that a clustered index must be a primary key or unique. You can create your clustered index on whatever columns you 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
February 12, 2010 at 6:59 am
I am not aware of any native tools that will allow you to do that. However, check out: http://www.hyperbac.com/ which does allow you to do what you are looking...
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 11, 2010 at 5:02 pm
Welsh Corgi (2/11/2010)
Jeffrey,Excuse me Sir but Im not sure that I understand your post?
Regards,
WelshS
If you have a system that is only accessed during business hours, say from 7am...
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 11, 2010 at 4:59 pm
Looking at your plan, I don't see that you are checking for the level of fragmentation on your indexes. If you are not doing that, then you are reorganizing...
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 11, 2010 at 4:50 pm
In addition to what Steve has stated, why do those databases need to stay on the 2000 instance? Can you move them to 2008 and leave them in 80...
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 11, 2010 at 4:41 pm
What kind of values exist in the DataValue column and what is the actual data type for that column? Why are you trying to convert/cast that value to 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
February 11, 2010 at 4:40 pm
I would add SLA's to the list of items to consider.
If you have systems that are generally only needed/used during business hours, you really don't want to comingle them 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
February 11, 2010 at 4:11 pm
Michael Valentine Jones (2/11/2010)[h]I was aware of that potential problem, and that is why I used the REPLACE to remove the - characters from the date to change 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
February 11, 2010 at 4:02 pm
On the query I provided, did you change the table reference back to your original table? I modified it to use a temp table instead. Here is 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
February 11, 2010 at 3:21 pm
Michael Valentine Jones (2/11/2010)
This will verify the correct format and ensure that it is a valid date.
ALTER...
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 11, 2010 at 3:15 pm
CirquedeSQLeil (2/11/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
February 11, 2010 at 3:07 pm
That list will only show you backups for that database that were performed on that instance. Since the backup you are looking for was not performed on that 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
February 11, 2010 at 3:04 pm
Viewing 15 posts - 4,141 through 4,155 (of 6,676 total)