Viewing 15 posts - 3,886 through 3,900 (of 6,679 total)
kk3 (4/29/2010)
TSQL from the jobs isEXECUTE master.dbo.xp_delete_file 1,N'F:\DBATEST',N'.trn',N'2010-04-27T16:56:20',1
cheers
kalyan
Remove the . in the extension parameter. If you compare the above with the one that is working, you'll see the one...
April 29, 2010 at 7:16 pm
alen teplitsky (4/29/2010)
if i play with the cost threshold, should i set the max degree of parallelism to 4 or 8 instead of the 1 that i tested with?
From what...
April 29, 2010 at 8:29 am
This is where powershell comes in very handy. Right-click on the database node in object explorer and open powershell - once there you can issue the following:
PS> Get-ChildItem |...
April 28, 2010 at 1:54 pm
You are welcome - thank you for the feedback.
April 28, 2010 at 1:41 pm
How did you move the logins to the new server?
If you just created them manually, or ran a script that created them - then you probably have orphaned users.
Run the...
April 28, 2010 at 1:29 pm
Oh - one more thing, use the catalog views:
sys.trace_columns
sys.trace_events
sys.trace_categories
sys.trace_event_bindings
sys.trace_subclass_values
With the above, you can convert the internal column/event id's to their external values.
April 28, 2010 at 12:42 pm
You can replace the function fn_trace_getinfo with:
SELECT * FROM sys.traces;
To get more information about the traces running, use the following functions:
fn_trace_getfilterinfo
fn_trace_geteventinfo
April 28, 2010 at 12:39 pm
Matt Miller (#4) (4/28/2010)
Jeff Moden (4/23/2010)
Bhuvnesh (4/23/2010)
Also check ANSI_NULL and ANSI_PADDING settings on both databases ?Spot on.
How is len going to be affected by either of those settings? I...
April 28, 2010 at 10:08 am
What have you tried so far? Lookup database_principals and server_principals in books online.
April 28, 2010 at 10:03 am
It sounds like you have a problem with the network between the servers. When backing up across the network the backup file is being corrupted.
Unless you can guarantee your...
April 28, 2010 at 9:57 am
chanti2985 (4/28/2010)
tlogbackup-everyday except sundayfull backup-sunday
Okay, then you really need to review the article on managing transaction logs that I link to in my signature. Either you are not actually...
April 28, 2010 at 9:13 am
My recommendation is to not shrink the databases - as I said before, it is just a waste of time.
April 28, 2010 at 8:50 am
That should fix the problem - unless there are other jobs doing the same thing.
April 27, 2010 at 7:38 pm
bilex7226 (4/27/2010)
April 27, 2010 at 7:36 pm
bilex7226 (4/26/2010)
That worked by creating a named instance for SSRS. I guess that correct right?
You should not have had to do that - but it shouldn't be a problem.
April 27, 2010 at 7:35 pm
Viewing 15 posts - 3,886 through 3,900 (of 6,679 total)