Hot answers tagged

6

Putting in a simple language : A login gives you access to server. A user gives you access to database. A login must map a user so that you can access the database. For SQL Authentication, you should create the login with SAME SID and map it to your user database/s on all the nodes with proper permissions (follow the principle of least privileged). This ...


5

A good option for you, I would imagine, is to split table logically, so every section would be in its own folder and have under 300k files(=records). In SQL Server logical table split is usually done with Partitioning (this is an Enterprise feature). Partitioning essentially maps sections of table (partitions) to physical storage (filegroups). Various ...


5

The backup file contains multiple copies of the database since it is not being "initialized" or "formatted" with each backup. Go to the 'Options' tabl on the "Back Up Database" dialog box, and select the "Overwrite all existing backup sets":


4

I'm assuming you are backing up to the same file each time. There is an option to INIT or NOINIT when you run a backup. NOINIT (which is the default) tells it to just add an additional backup to the file. Per BOL: { NOINIT | INIT } Controls whether the backup operation appends to or overwrites the existing backup sets on the backup media. The ...


3

TailLog backup contains the transaction log that was generated after the last log backup.so this is necessary if you want to restore to latest point in time.When we try to restore the database which is online and whose tail log has not been backed up ,SQL Server will throw the error you are getting To avoid this error use NoRecovery. But with above ...


2

After posting this question and getting some comments about upgrading SQL Server to the latest SP, I found this KB article. The behavior described in the article seemed to be very similar to what we were seeing. We went ahead and applied SP3 + CU3 to get to the most recent version of SQL 2012 that we could. After installing the SP and CU, the problem ...


2

After much frustration and fruitless googling, I finally figured out the problem. It was not that the accounts for the 'SQL Server' and 'SQL Server Agent' services did not have access to the directory. The problem was that the account for the 'Log Reader Agent' did not have access. Should have been obvious from the error message, but I just didn't get it... ...


2

No, dropping a synonym requires a Sch-M lock, and also IX locks on sysschobjs/sysobjvalues, at least if it is on the same server (I haven't tested what happens when the synonym uses a 4-part name). What exactly would it mean if you could change a synonym in the middle of a query or transaction? If you have a query plan operator or a cursor which needs to ...


2

So, after lots of hard thinking and trial and error (mostly error I must admit), it seems I stumbled upon an answer to my question. I did the following: create a temp table will hold the result, let's call it result. fill result with the packaged data. update the temp table with the produced order. The temp table: CREATE TABLE ...


2

The Memory Use column - where is it coming? It corresponds to memory_usage column in sys.dm_exec_sessions. As a friendly note, I would suggest not to use Activity Monitor. Use Adam Machanic‘s free procedure, sp_WhoIsActive (uses DMVs). You can even log into a table for post analysis. Kendra Little talks about Activity monitor limitations : It ...


2

I had similar error few months ago and solved by this. USE master; GO EXEC master.dbo.sp_delete_log_shipping_primary_secondary @primary_database = N'<PrimaryDatabase>' ,@secondary_server = N'<SecondaryServer>' ,@secondary_database = N'<SecondaryDatabase>' GO


1

There are couple of options -- I would not suggest to go with replication as you are making schema changes and it will require to reinitialize the whole replication with a snapshot. Logshipping with standby option: Cheap and effective. Works great and less overhead of maintenance. Things to look out : If an adhoc log backup is taken, it will break ...


1

You just installed SQLManagementStudio_x64_ENU this is SQL Server management studio. This is a tool used to connect to SQL server database engine. Since you have not installed SQL Server database engine you cannot connect. You have to browse This Link Click on download Then you would get something like below Downlaod the files marked in rectangle. ...


1

You don't state the steps you take in each case so it is difficult to give specific analysis but three generic explanations for some of the difference spring to mind: Rebuilding is an offline operation unless you are using Enterprise Edition, so it takes a table lock and does all the work before letting any other processes touch it. This means the process ...


1

It is not unusual for a query to drop PLE. Queries can consume arbitrary amounts of memory. This generally happens for two reasons: Work memory for sorting and hashing. Filling the buffer pool with data that was read. You can prove that (1) is happening by watching outstanding memory grants from the respective DMV while the query runs. If the query ...


1

For the purpose of this answer, I am assuming your INSERT statement looks something like this: INSERT INTO dbo.vSubCategories (CategoryName, SubCategory) SELECT CategoryName, SubCategory FROM ... /* reading rows either from the CSV directly or from a staging table into which the CSV has been imported */ ; So, the first thing your ...



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