Viewing 15 posts - 1 through 15 (of 93 total)
Take a look at this documentation.
Because you're initializing from a backup, there's a few things you have to do (listed in the article). If you search for "sql server...
March 5, 2020 at 3:19 pm
Yeah, as much of a pain as it will be, I would manually apply SP's and CU's to SQL Server, even if it is a large environment.
Which makes me wonder...
March 4, 2020 at 3:38 pm
Are there multiple versions of SQL Server in your environment? Or are they on a particular version? The reason I ask is because some of the recent CU's for SQL...
March 4, 2020 at 2:47 pm
Permissions would be the only concern. Is the developer doing this in a test/dev environment? If so, then it should be fine. If it is in production, I would be...
March 3, 2020 at 8:06 pm
Cross-post on DBA Stack Exchange
Have you tried the advice from the comments posted there?
February 25, 2020 at 3:10 pm
I agree with Brian Gale, you need to go to the local server. You may need to add the AD group to the Security page in the Reports web screen....
February 13, 2020 at 8:35 pm
It really depends on how you intend to use it. However, any SQL Server service outside of the engine will use resources (memory being one of the main ones along...
February 3, 2020 at 8:54 pm
I forgot about the log file in my example...probably because I usually don't put the log file with the data files. Yes, if you're going to have the log file...
January 30, 2020 at 5:59 pm
Our main Enterprise Edition server only ever hits about 1K transactions/second as opposed to the 8K I am seeing on this server.
What is the server with the problems being used...
January 29, 2020 at 9:57 pm
If you search for "sql server temp db best practices", one of the top results is this link from Brent Ozar:
It is probably very common practice now to have...
January 29, 2020 at 4:47 pm
Transactional replication sounds like the way to achieve your goal. It allows replication of all or a subset of the database objects (tables, views, etc) called articles in replication.
To get...
January 27, 2020 at 3:27 pm
A very good article on this subject is:
https://www.brentozar.com/archive/2019/09/dba-training-plan-19-the-l-word-licensing/
I agree with Anthony too...the reseller or MS is the definitive source of truth as they are the ones who may do...
January 24, 2020 at 5:48 pm
As far as I know, this cannot be done. I tried it with an AdventureWorks database I have on my local machine, and it failed with a generic error. And,...
January 2, 2020 at 4:27 pm
If the database is corrupted won't the "backup" (I assume this means a copy of the .mdf file) of the file contain the same corrupted data as running a full...
January 2, 2020 at 3:07 pm
Instead of trying to attach the files, have you tried restoring them, with a new database name, using the backup you have of the main database?
January 2, 2020 at 2:42 pm
Viewing 15 posts - 1 through 15 (of 93 total)