Hot answers tagged

4

I know this is an old question, but it is the first question that shows up when searching "commvault" on serverfault. I have two years of experience with Commvault Simpana v9 and v10 as a support technician and a year as a systems engineer. First Question To answer your first question, yes, a typical database restore creates .mdf and .ldf files ...


2

Select the database as the active database-context using use before executing the SELECT-Statement. So it would: USE mydatabase; SELECT column_name FROM information_schema.columns WHERE table_name = 'Admins'; An alternative would be to include the database as a prefix to the information_schema like this: SELECT column_name FROM [mydatabase]....


1

Is there anything else in Sql Server 2016 that wants Windows Server 2016 to work well? Or would I be fine with a Windows Server 2012 R2? There are a slew of new and updated features in Windows Server 2016. Unless any of them are specifically important to you, for example enhancements to storage spaces and CSV storage, I wouldn't specifically call out a ...


1

There could be a variety of reasons why this is going wrong. Most of which are related to the SQL Server components installed with VS2015. When VS2015 is installed, the default behavior is to also install the SQL Server data tools. These need to be compatible with the version of SQL Server that you're currently running. What I would do to troubleshoot your ...


1

The PDO connection couldn't find the driver for me when using the curly braces. After removing those, I was able to connect just fine. Note my usage of the double quotes for the connection string which allows variable expansion. $mssqldriver = 'ODBC Driver 11 for SQL Server'; $connStr = "odbc:Driver=$mssqldriver;SERVER=<redacted>;DATABASE=<...


1

When you start an agent job, it returns immediately with a success message. Take a look at this post (http://agilebi.com/cs/blogs/jwelch/archive/2009/02/20/check-for-sql-agent-job-completion.aspx)


1

I had the exact same problem and I found that it was caused by not enough memory allocation on the Hyper-V VM. I had memory set to dynamic but it was not scaling up as required - switching to a fixed amount of memory, in my case 32GB, solved the problem. The interaction between SqlBulkCopy and Sql Server does not seem able to get more memory when required??


1

When upgrading from one version of SQL Server Management Studio to another, e.g. 2014 to 2016, you can copy the SqlStudio.bin file from one directory to another and all of your connections will migrate to the new version. Shut down all instances of SSMS. Rename SqlStudio.bin to SqlStudio.bin.saved in "C:\Users\<username>\AppData\Roaming\Microsoft\SQL ...


1

Check the Publication Properties-->Snapshot-->Location of snapshot Files-- Make sure put files in the default folder is checked, in my case it was't check marked instead put files in the following folder was checked with a location address(C:\REPL) but i had my distributor in a different server other than publisher and the location address was misleading ...



Only top voted, non community-wiki answers of a minimum length are eligible