Viewing 15 posts - 121 through 135 (of 984 total)
Yes, you can, but you have to set up multiple backup jobs with different `@CleanupTime` and `@Databases` parameters. Just make sure they don't overlap / contradict each other, you'll be...
May 23, 2018 at 2:48 am
DNS alias? That works - I've used it on occasion.
May 22, 2018 at 8:14 am
May 21, 2018 at 5:39 am
May 21, 2018 at 2:42 am
May 18, 2018 at 2:38 am
May 17, 2018 at 9:35 am
May 17, 2018 at 5:51 am
May 16, 2018 at 6:54 am
Had the database been dropped and recreated between you connecting to it and you then attempting to query it?
May 14, 2018 at 12:33 pm
Have you tried opening a different instance of SSMS?
OK, that was a wild assumption.
Are there any other error 18456s from the same time? Say, State 38?
May 14, 2018 at 9:43 am
May 14, 2018 at 9:39 am
This is something that would normally be done at the presentation layer...
...however, check out the FORMAT function. https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?view=sql-server-2017
May 10, 2018 at 8:08 am
Is it failing consistently at a particular time? If so, what else is going on then?
May 9, 2018 at 9:22 am
Viewing 15 posts - 121 through 135 (of 984 total)