Viewing 15 posts - 4,921 through 4,935 (of 6,676 total)
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...
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
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.
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
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()) -...
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
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.
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
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...
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
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...
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
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...
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
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. 😀
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
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...
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
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...
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
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...
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
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...
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
June 26, 2009 at 12:15 pm
We create a minimum of 3 cluster groups:
Cluster Group - contains the cluster resources
MSDTC Group - contains the resources for MSDTC
SQL Group...
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
June 26, 2009 at 12:03 pm
Why do you think it is not working? If you have a very large number as the restricted size of the file, are you aware that the number is...
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
June 26, 2009 at 11:57 am
GilaMonster (6/26/2009)Log yes, diff no. Differential backups do not require an intact log chain. Only log backups require that.
But, if you perform a backup using Backup Exec - and it...
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
June 26, 2009 at 9:42 am
Viewing 15 posts - 4,921 through 4,935 (of 6,676 total)