Viewing 15 posts - 3,511 through 3,525 (of 6,679 total)
nathan 7372 (11/17/2010)
It is just a maintenance plan Full backup
2. What is...
November 17, 2010 at 8:39 pm
SqlN00bie (11/17/2010)
Temecula, California is where I'm at.I'll send a message to 'TheSQLGuru' per your high recommendation.
Thanks a lot!
I am not a performance specialist - and Kevin is...
November 17, 2010 at 4:06 pm
Those groups in SQL Server are tied to the local groups on the server. If the local groups on the server have been renamed, then you need to change...
November 17, 2010 at 3:58 pm
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...
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...
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...
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...
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...
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...
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...
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...
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.
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...
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...
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...
November 3, 2010 at 5:16 pm
Viewing 15 posts - 3,511 through 3,525 (of 6,679 total)