Viewing 15 posts - 4,921 through 4,935 (of 6,679 total)
Chris (6/29/2009)
Oh boy,, Now I've done it.My apologies to the forum.
I'm running SQL 2005 Ent.
Sorry all
Chris...
No problem, but that does mean you probably had an issue with copy/paste of...
June 29, 2009 at 9:20 am
Scott Duncan (6/28/2009)
In my experience with SQL Server 2005, SQL Server won't backup to a drive unless it is added as a dependency to the SQL Server service.
Not...
June 28, 2009 at 6:50 pm
I would probably approach this a bit differently. It would require an additional downtime, but I think it would be worth it.
1) Remove second node from cluster
...
June 28, 2009 at 12:03 pm
If I am reading this correctly, you have two tasks setup that are using the Execute SQL Agent Job tasks in a maintenance plan. You have placed precedence contraints...
June 28, 2009 at 11:40 am
I don't use a separate backup group - so I really couldn't say what advantages there are.
June 27, 2009 at 11:29 pm
Here are a few things for you to look at:
Select dateadd(minute, 990, dateadd(day, datediff(day, 0, getdate()), 0))
,dateadd(minute, 990, dateadd(day, datediff(day, 0, getdate()) -...
June 27, 2009 at 7:45 pm
You don't check that from SQL Server - you check that from Windows. That is normal file share security.
June 26, 2009 at 8:31 pm
No need to delete or remove the existing databases. The restore operation will overwrite the existing files.
I would recommend taking the databases offline first - then restoring. That...
June 26, 2009 at 8:20 pm
If the service account running SQL Server and SQL Server Agent has access to the shared folder then yes, you can backup to that folder. If you are not...
June 26, 2009 at 8:17 pm
klnsuddu (6/26/2009)
For example, if the drive is not in the same group - the SQL Server cannot see the drive. So, for backups you would have to reference the...
June 26, 2009 at 3:36 pm
Sorry about that - I didn't take the time to look it up and I get it wrong all the time. 😀
June 26, 2009 at 2:28 pm
Hey everyone, you don't need a CMS available to do this. All you need is the 2008 client installed. Once you have that, create a group in Registered...
June 26, 2009 at 1:39 pm
To fix this, put SET FORMAT_ONLY OFF; at the beginning of your procedure. Be aware that doing this causes SQL Server to actually run the procedure, and if it...
June 26, 2009 at 1:21 pm
Not so much a question of right/wrong - but, more like which is better for you. I don't see a problem with having a resource group setup just for...
June 26, 2009 at 12:47 pm
It is not a problem, but why would you spend that kind of money and allocate those kinds of resources to support such a small system?
Are you looking at adding...
June 26, 2009 at 12:15 pm
Viewing 15 posts - 4,921 through 4,935 (of 6,679 total)