Viewing 15 posts - 2,746 through 2,760 (of 39,723 total)
I can't remember most days which day it is. Mostly because I think it doesn't matter and then I don't pay attention. I check the display in my monitor (from...
May 11, 2020 at 1:36 pm
It is a logical file name, but from my reading, that is bound below the Filegroup. There isn't a Filegroup for the log.
May 9, 2020 at 3:22 pm
Yes, I'd certainly use a separate account for this. Should be able to be a backupadmin and then perhaps file system rights if there is a copy involved.
May 9, 2020 at 3:21 pm
I don't see log file listed here: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/extended-properties-catalog-views-sys-extended-properties?view=sql-server-ver15
May 8, 2020 at 3:50 pm
Haven't seen that, and it shouldn't matter. During the backup process, if you are writing to a remote share, I don't think permissions are rechecked in midstream. It's possible some...
May 8, 2020 at 3:50 pm
You will need jobs on the DR instance, disabled or checking for whether this is the primary replica before running.
May 8, 2020 at 3:49 pm
Thanks, all. I do try, as do my fellow advocates. It's a great job, and I hope we continue to do it for a long time.
May 8, 2020 at 3:48 pm
You can look for filestream on tables, which is not supported in Azure SQL database. The list of things not supported is here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features
May 8, 2020 at 3:47 pm
I haven't dealt with Access attachments, but I'd agree a separate table is needed. These might be docs in the file system, with a pointer in the Access db. FileStream...
May 7, 2020 at 8:09 pm
My apologies. I started to reply yesterday and got sidetracked.
Here's my view. I'm not a lawyer, auditor, or regulatory reviewer. Your job is to be compliant with SOX auditing. From...
May 7, 2020 at 8:06 pm
The formatting of lines was a render issue. Old coding v new coding, and it took time to fix. Despite what you see here, this isn't a high priority item...
May 7, 2020 at 3:54 pm
I'm sorry you find these hard to use. We've adopted different choices for software over the years, so old posts might reference things that no long exist. It's not practical...
May 6, 2020 at 8:26 pm
the listener is the SQL Browser. Not on by default, but if you connect to 1433, and you have a local instance running on 1433, that shouldn't matter. You are...
May 6, 2020 at 3:00 pm
The native client replaces older drivers. This is a few MB in size. Not worth uninstalling. You might not use it now, but you may at some point.
May 6, 2020 at 2:57 pm
One last thing, you noted "The database should not lose user accounts or logins after the restore from prod backup". Logins are an instance (server) level object, so database restores...
May 6, 2020 at 2:56 pm
Viewing 15 posts - 2,746 through 2,760 (of 39,723 total)