Viewing 15 posts - 4,096 through 4,110 (of 6,676 total)
The best way to automate tasks on the server is whatever works the best for your situation. There is no one size fits all automation tool.
As for Powershell -...
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
February 20, 2010 at 3:48 pm
cmd.CommandType = System.Data.CommandType.Text
cmd.CommandText = _
" SELECT O.OrderID, SUM(OD.UnitPrice * OD.Quantity)" & _
" FROM dbo.Orders O " & _
...
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
February 20, 2010 at 3:43 pm
Like I said before, if you are concatenating strings and passing those strings you really should change your code. In it's current form, you are open to a SQL...
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
February 20, 2010 at 2:19 pm
Also, since you are using ASP - you probably want to make sure you are using parameters instead of concatenating the date to a string and passing the string 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
February 20, 2010 at 1:38 pm
If you are passing in your date in a format that is affected by regional settings, you would get this error. For example:
01/02/2010 can be interpreted by SQL Server...
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
February 20, 2010 at 1:36 pm
If there is no key on the case, or stamped on the CD - then you need to contact Amazon and ask them for it. Sorry...
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
February 19, 2010 at 9:59 pm
Paresh Randeria (2/19/2010)
I understand that writing in the log file is sequential but because it is very very heavy insert into the multiple...
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
February 19, 2010 at 9:57 pm
It may have been pre-pidded. Have you tried installing and seeing if it prompts for 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
February 19, 2010 at 8:39 pm
This is just the same recommendation you get when installing any software. FWIW - I have never had any issues with virus scanners causing issues during SQL Server installations...
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
February 19, 2010 at 8:24 pm
klnsuddu (2/19/2010)
So the no of disks that make up the array that hosts the z:\ drive is 1 right? please correct me
This does not sound right - there 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
February 19, 2010 at 8:18 pm
Right-click on the maintenance plan and select View History. This will show you the history for the plan and which task actually failed. Select the failed task and...
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
February 19, 2010 at 8:10 pm
Did you read the article I linked to? It explains this all in great detail.
Regardless of your experience, if your database is in full or bulk-logged recovery model 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
February 19, 2010 at 6:52 pm
Thank you Jason - couldn't have said it better myself...in fact, I didn't 🙂
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
February 19, 2010 at 6:43 pm
schleep (2/19/2010)
No tran. log backups required, since there is no other activity on 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
February 19, 2010 at 8:53 am
If the history on the maintenance plan shows as successful, you have a backup file for all system databases and the job has failed, most likely the reason is because...
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
February 19, 2010 at 8:51 am
Viewing 15 posts - 4,096 through 4,110 (of 6,676 total)