Viewing 15 posts - 3,511 through 3,525 (of 6,676 total)
dennis.malone (11/17/2010)
Thought about that too, but if the source table changed since the first snapshot and you needed to preserve that point in time that would not work
The only option...
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
November 17, 2010 at 3:48 pm
SQL Server backups will run in the context of the SQL Server service account, not the SQL Server Agent service account.
I don't think this is your problem. I think...
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
November 17, 2010 at 3:18 pm
I use maintenance plans also - and also use a hybrid approach. Including using the Execute SQL Task in the maintenance plans to replace tasks as needed.
For example, 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
November 17, 2010 at 3:15 pm
Yes, you can turn off those text files. In the maintenance plan, there is a button next to the Manage Connections button where you can configure reporting.
In that dialog...
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
November 17, 2010 at 3:11 pm
If your mirroing is setup in asynchronous mode, there is no reason to pause mirroring and resume it later.
However, if you are running in synchronous mode - you can pause...
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
November 16, 2010 at 4:31 pm
Chrissy321 (11/16/2010)
Now when I try to View T-SQL for the maintenance task I get the error on a different index.Can anyone recommend a good script for this purpose?
The default...
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
November 16, 2010 at 2:11 pm
The technical answer is: It depends...
It depends on what SAN you are using, how many actual spindles are defined for your LUN - how that is utilized on the SAN...
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
November 13, 2010 at 7:25 pm
hydbadrose (11/10/2010)
This is installed as cluster, but for some reason the node b is missing the default instance.
If this were true - then you would not be able to failover...
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
November 12, 2010 at 12:58 pm
Check to see whether or not there is a tape backup job that is backing up that file to tape.
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
November 9, 2010 at 2:23 pm
p.brat.23 (11/6/2010)
In our case, data file is 96% used and we are getting alerts as it crossed the threshold.
So I tried to increase the datafile size but...
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
November 7, 2010 at 10:31 am
Your only option is to create a new server installed with x64 OS and SQL Server. Once installed, you backup the databases on the IA64 system and restore them...
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
November 3, 2010 at 5:19 pm
Neither Virtualization or Clustering is a method to use additional resources from other hardware. A virtual machine is hosted on a single physical server - but can then be...
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
November 3, 2010 at 5:16 pm
GSquared, your solution is not quite the same as the original unions. With the unions - if modifier1 and modifier2 both have values - and those values are 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
November 3, 2010 at 2:22 pm
Instead of viewing the job history, you need to look at the maintenance plan history. Right-click on the maintenance plan in Object Explorer and view history.
Find the step 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
November 2, 2010 at 2:08 pm
pavan_srirangam (11/1/2010)
But kimberly says you have to set it single...
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
November 1, 2010 at 7:35 pm
Viewing 15 posts - 3,511 through 3,525 (of 6,676 total)