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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 3, 2020 at 8:06 pm
Cross-post on DBA Stack Exchange
Have you tried the advice from the comments posted there?
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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....
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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,...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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?
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 2, 2020 at 2:42 pm
Viewing 15 posts - 1 through 15 (of 93 total)