Viewing 15 posts - 2,866 through 2,880 (of 6,676 total)
MysteryJimbo (5/18/2012)
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
May 19, 2012 at 9:35 am
SAN level snapshots will work - if they are done correctly and managed by the SAN vendors software it is very likely you will have the ability to perform 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
May 18, 2012 at 1:16 pm
You could also consider database mirroring. Setup the mirroring and when you are ready - failover to the partner, redirect your users and tear down the mirroring.
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
May 16, 2012 at 3:04 pm
I would keep it on the tempdb LUN myself, but it would really depend on how heavily tempdb is used on your system and how the LUNs were built, 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
May 12, 2012 at 9:05 am
If you have the storage available for the raw data on the server, then you should be able to BCP out the data from the table, truncate the table, add...
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
May 12, 2012 at 8:53 am
I have a 1.8TB database that is currently using 1.6TB of that space. The backups take about 2 hours to complete using Litespeed and I restore that backup 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
May 5, 2012 at 8:10 am
As soon as any other application accesses that database and updates data - you will have data integrity issues. In other words, the only way to insure data integrity...
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
May 5, 2012 at 8:01 am
SCHEMA_NAME (http://msdn.microsoft.com/en-us/library/ms175068(v=sql.100).aspx)
OBJECT_SCHEMA_NAME (http://msdn.microsoft.com/en-us/library/bb326599(v=sql.100).aspx)
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
April 29, 2012 at 9:00 am
Kevi322000 (4/16/2012)
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
April 16, 2012 at 8:11 am
On SQL Server 2008 - I would recommend using CAST({value} AS DATE) instead. This has been optimized so it can still use index seeks where possible and will still...
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
April 15, 2012 at 8:16 am
balasach82 (4/14/2012)
Now, I am clear that after dividing the files of tempdb,
1. SQL restart not required
2. Divide the data (mdf) files, like, temp1.mdf, temp2.mdf...
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
April 14, 2012 at 7:35 am
The message clearly states that you should look in the maintenance plan history. Have you done that yet - and if so, what is the error you see from...
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
April 14, 2012 at 7:33 am
You could also purchase SQL Prompt (Redgate) or SQL Assistant (SoftTree) and configure those to your standard. This way, you don't have to worry about hitting the shift key,...
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
April 4, 2012 at 11:55 am
In the organizations I have worked for - we utilize Ghost or something similar to build workstations. I tell developers that if they do anything that causes a lot...
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 24, 2012 at 8:10 am
If you have a published naming standard for your organization then you can enforce that policy. If you don't have one - and this is an issue - 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 24, 2012 at 8:02 am
Viewing 15 posts - 2,866 through 2,880 (of 6,676 total)