Viewing 15 posts - 1 through 15 (of 42 total)
Just to clarify, is the job still running, and the notification you got was for a failure in one of the steps?
May 18, 2015 at 2:30 am
Eirikur Eiriksson (5/1/2015)You could use System Restore to the earliest point available, patch the OS and then install the SQL Server.
😎
That's a pretty good idea!
Otherwise, it'll be just the usual...
May 1, 2015 at 5:25 am
Yep: safest bet is to nuke the entire server from orbit. It's the only way to be sure.
I've had too many problems in the past with nasties clinging on from...
May 1, 2015 at 2:29 am
Just to add (hopefully) a little extra support to the excellent advice already given:-
It is usually not a good idea to shrink your database - it grew to that size...
May 1, 2015 at 2:22 am
Daft question from me, maybe, but is the main Job Activity Window not sufficient?
It shows all the jobs, you can order them in a variety of ways, and it shows...
April 30, 2015 at 2:01 am
kevaburg (4/30/2015)I can't post data unfortunately because it is live production data based on sales Information!
Just a quick caveat having read your comment above, and not wishing to teach grandmother...
April 30, 2015 at 1:53 am
Yeah it's nasty.
Pretty much the first step in any installation document I write (if the organisation doesn't have one, or amend if they do) is to create a Windows group...
March 25, 2015 at 6:35 am
Grant
Would the discussion I had with a different user HERE be of use?
I didn't hear anything back from them in the end, but the technique is supposed to work.
I've not...
March 25, 2015 at 5:27 am
The figure you've seen is the default and was what I expected once I had realised that you'd basically just followed the standard installation documentation.
I think this opens up a...
March 17, 2015 at 5:51 am
Yes indeed - to quote from TechNet:-
To set a fixed amount of memory
In Object Explorer, right-click a server and select Properties.
Click the Memory node.
Under Server Memory Options, enter the amount...
March 17, 2015 at 5:16 am
First question, as we can see a difference in caching:-
Do the settings for "memory made available to SQL Server" vary between the two instances?
March 17, 2015 at 4:37 am
ZZartin (3/11/2015)
March 16, 2015 at 4:14 am
Yep, as Piet says, you need to CREATE a sproc before you can execute it. Think of the CREATE statement as "installing" the stored procedure in one of the databases...
March 16, 2015 at 3:59 am
Hmmm.
The reason for my questions was mainly because I have seen something similar in the past with SQL Server 2008 R2, using LiteSpeed for the backups, and BackupExec for the...
March 10, 2015 at 3:59 am
Paul, a few questions to start us off:-
1. Is this a native SQL backup or does it use something like LiteSpeed?
2. Compressed or not?
3. What file backup solution are you...
March 9, 2015 at 5:04 am
Viewing 15 posts - 1 through 15 (of 42 total)