Viewing 15 posts - 1 through 15 (of 50 total)
Hi @Andy you remember the environment you had help me migrate? well, that whole server and it backup infrastructure just failed drastically. We were able to recover the...
March 28, 2020 at 2:47 pm
This is a very neatly compiled article. Thank you for it.
One more thing I find all of us DBAs have to do is to run SSMS against...
August 15, 2017 at 8:09 am
so yes, I found that in the sysjobsteps, there is a "command" column that lists the databases that are being backed up
from this, I can get a job_id which...
February 1, 2017 at 12:24 pm
February 1, 2017 at 10:55 am
where did u fix the "sql service account's permissions"?
January 5, 2017 at 7:06 am
I just got the same error.
Anybody find a resolution to that?
February 29, 2016 at 7:07 am
I found the problem and resolved it. Not sure why the problem is...
The backup location was \\ip_address\backuplocation.
After a network glitch somehow that translation of ip_address got lost.
I just replaced it...
August 6, 2015 at 12:02 pm
Step ID1
Servers1
Job NameLSCopy_451648-S2_db_WORK
Step NameLog shipping copy job step.
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
2015-08-06 11:55:22.59*** Error: The specified network name is no longer available.
(mscorlib) ***
2015-08-06 11:55:22.61----- END OF...
August 6, 2015 at 9:57 am
one more thing.
There are three phases in the job
lsbackup- works
lscopy- fails
lsrestore- kinda works because there are no files to apply; since copy failed.
August 6, 2015 at 9:15 am
Thanks for quick responses.
The service runs under domain account. The account is local admin on the box and an SA for now.
Hope this helps.
Regards
Paresh
August 6, 2015 at 9:09 am
I have a similar case but the retention for the files is 14 days. The job once failed did not succeed at all.
I even copied one of the files for...
August 5, 2015 at 12:34 pm
Hi Lowell, that has already been working . The customer doesn't need that. we just need to be able to attach the files without having detached them...
June 26, 2015 at 2:47 pm
I got this to work:
get-clusteravailabledisk | Add-ClusterDisk
Add-ClusterSharedVolume -Name "Cluster Disk 4"
Start-ClusterResource "Cluster Disk 4"
Move-ClusterResource -name "cluster disk 4" -Group "SQL Server (MSSQLSERVER)"
May 15, 2015 at 6:41 am
I have to write a script so this process is automated for a customer.
I dabble in PS but not that deeply hence the question.
Hope this helps
Paresh
May 13, 2015 at 9:55 am
Hi Perry, this is very elaborate. Thanks for sharing.
But I was looking for a PowerShell based solution.
P.S. this is not an AO AG.
Cheers
Paresh
May 13, 2015 at 9:00 am
Viewing 15 posts - 1 through 15 (of 50 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy