Viewing 15 posts - 1 through 15 (of 23 total)
Great article. I was able to go through the examples and I ended up with a question on the logic for the last backup.
When I run it I only get...
April 7, 2020 at 2:40 pm
Great detail on your methodology.
I would suggest taking a look at the powershell module dbatools.io. It will take care of a lot a lot of your steps for...
July 20, 2018 at 2:10 pm
Yes, the command will copy all logins or a specific one or filter out specific ones. Check out the examples at.
November 1, 2016 at 8:36 am
------------------------------------------------------
-- FULL TEXT QUERY FREETEXT
------------------------------------------------------
--from gs_Subscriber where freetext((FirstName,LastName,GSCustomerNumber,Phone), '"%Juan Gomez%"')
declare
@FirstName nvarchar(25) = NULL,
...
November 28, 2012 at 5:58 am
That is our current configuration. I have a master file that is copied. Somehow the master file gets deleted and we cannot identify what is deleting the file....
August 23, 2012 at 6:48 am
Great article. It always amazes me how many people don't know about this feature. I still find servers in our infrastructure that do not have it enabled.
I have...
July 30, 2012 at 7:54 am
Yes, log shipping is disabled. However, the LSCopy* and LSRestore* agent jobs are still on the server. We are just trying to cleanup disabled and un-needed jobs.
December 7, 2011 at 6:20 am
Ok, mine is in mixed mode when I run it. Maybe that is the difference.
July 21, 2011 at 6:24 am
I think I figured it out. The main table has an identity column and that is created when I do the SELECT INTO. Then no records are getting...
June 29, 2011 at 1:56 pm
Actually it is not for users. We are trying to turn over the deployment/implementation of our products to our support department to free up development resources. So it...
May 17, 2011 at 12:13 pm
There is a command line utility that comes with Quest LiteSpeed that allows you to decomporess and restore a LiteSpeed backups without it being installed on the box.
If you already...
December 15, 2010 at 7:04 am
Your scaryDBA.com link is broken in your article.
I am looking forward to the contests.
December 8, 2010 at 7:40 am
I figured it out.
Had to make the backup size varchar bigger.
December 2, 2010 at 1:38 pm
I have also seen where userid and password in my connection string of my app are not correct and I see that error. You might also check on your...
November 9, 2010 at 1:25 pm
Viewing 15 posts - 1 through 15 (of 23 total)