Viewing 15 posts - 151 through 165 (of 171 total)
I have done this one time with a vm - You could create the new server (with new hardware) with a temporary name, install sql, then either restore or attach...
June 8, 2016 at 7:05 am
Right, not the login you are using to login to the sql server to run the install, but, was referring to setting the logins for the sql services inside the...
May 27, 2016 at 11:29 am
I would un-install what you were able to install (add/remove programs), if anything, reboot, and re-start the 2014 installation from scratch. Instead of using the default logins for the...
May 27, 2016 at 8:36 am
Pretty sure there is not a "downgrade edition" option in setup only an "upgrade edition" one. You could possibly do a side by side migration and restore the databases...
May 25, 2016 at 3:21 pm
With regard to the login messages you are not wanting to see in the Sql Server Error log - while in SSMS, rt click on the sql instance>Properties>Security and change...
May 11, 2016 at 3:31 pm
You should not have to as long as the 2014 installation was successful. I would check the numerical part of the version installed (Select @@version) and cross check that...
May 11, 2016 at 3:18 pm
I searched on your error, and I think is is pointing to a permission issue, please make sure your account, or the account you are accessing the server with the...
April 28, 2016 at 8:54 am
There is a free downloadable program from MS called "Kerebos Configuration Manager", if you search on it, you should be able to download it and run it against your server(s)...
April 28, 2016 at 7:50 am
You could set up log shipping for the databases from your 2008 clustered instance over to the new 2014 vm instance. Then, at cutover time, stop all applications pointing...
March 30, 2016 at 7:06 am
The retention time to keep backups on disk is embedded within the backup script which Ola provides - Example - sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d zUTILITY -Q "EXECUTE [dbo].[DatabaseBackup]
March 29, 2016 at 12:40 pm
Thinking a VM should work fine for a test server assuming that vm is equipped enough RAM and cpus to run all the applications going on it. Of course,...
March 24, 2016 at 7:25 am
What will be the effect of index reorganization to the users?
The reorgs, while they are running, should go un-noticed by the users (application). You can even stop a rerog...
March 21, 2016 at 1:23 pm
If you are looking for a query to query the indexes to maybe do this manually, you could use this script below:
SELECT OBJECT_NAME(ips.object_id) AS table_name,
...
March 17, 2016 at 11:56 am
How big is that drive (X:\) in total? The total size of tempdb according to your code will be 560gb. It is probably good to always leave 10% -...
March 17, 2016 at 7:43 am
Looks like you have run into one of the limitations of AGs:
"The host computer must be a Windows Server Failover Clustering (WSFC) node. The instances of SQL Server that host...
March 11, 2016 at 11:50 am
Viewing 15 posts - 151 through 165 (of 171 total)