Viewing 15 posts - 1 through 15 (of 54 total)
Sorry folks, I made a slight error in communication I think. The database in question gets a full backup every week not every month as incorrectly implied. When I say...
January 16, 2024 at 4:59 pm
Thank you most kindly Scott for the approach. Let me investigate this (to get my head around it) and I will post if I get stuck. Many, many thanks to...
January 12, 2024 at 5:05 pm
Hi, thanks for the advice. The database in question is interesting in the sense that its a financial number storing database whose values are rebuilt (ie lots of calculations &...
January 12, 2024 at 4:02 pm
Hi everyone, thanks for the speedy response. Take it easy oneme though, I'm just a developer not a db admin! I will try and answer your queries:
1. Recovery model is:...
January 12, 2024 at 2:59 pm
Thanks for the speedy reply. The type of use of is in 2 ways
Way 1): Extract at a later stage. The Cr+lf can & does muck up nice formatting later...
November 29, 2023 at 2:53 pm
Thanks for the speedy reply Ken.
I ran the the following command (as sysadmin) and got:
EXEC sp_xp_cmdshell_proxy_account 'SERVERNAME\XPCmdShellProxy', 'somePassword';
but got the error:
"An error occurred during the execution of sp_xp_cmdshell_proxy_account. Possible reasons:...
February 22, 2023 at 4:06 pm
Thanks for the links (esp. the first one).
I made more progress and also found this script here to be immensely useful: https://dba.stackexchange.com/questions/201776/grant-user-from-my-database-to-execute-xp-cmdshell
On the server itself in control panel...
February 22, 2023 at 1:52 pm
Hi Grant, thanks for your feedback. I think I'm going to move away from Maintenace Plans and use the relevant sql code as I will have more control over the...
February 9, 2023 at 12:11 pm
Sincere thanks to all those who contributed. I have better understanding of the issues involved and the coverage required. Much appreciated, J.
November 17, 2022 at 3:10 pm
Hi everyone,
Thank you all for your comments & practices you suggestions, many of which we are already doing. To answer you queries:
We are doing the weekly full back directly to...
November 16, 2022 at 3:58 pm
Hi Sue,
Thanks for the suggestion. I t was already added but I tried again and moved it around etc for blank and standard templates and tested a...
May 18, 2018 at 4:26 am
Hi Jeff (no, the other one)
Thanks for the suggestions. I tried a few different templates and a few other variations and while handy, I still cannot get...
May 17, 2018 at 9:14 am
Hi Jeff, yes the "TextData" column is displaying. I have played with it's location relative to the other ie first, second last position but when I click on the rtow...
May 17, 2018 at 3:24 am
Lets use a database restore as an example:
RESTORE DATABASE TestRestore
FROM DISK = 'SomeCorrectPath'
WITH RECOVERY,
MOVE 'WrongDataName' TO 'D:\SQL2014\Data\TEMPCOPY.mdf',
MOVE 'WrongLogFile' TO 'E:\SQL2014\Logs\TEMPCOPY.ldf'
The above will throw an error as the logical file names...
July 26, 2016 at 6:43 am
Thanks for the advice. Forgive me but how do you create a different SQL instance lets call it "TestInstance"
June 13, 2016 at 5:37 am
Viewing 15 posts - 1 through 15 (of 54 total)