Tag: sql-server-2012

Backup/Restore from different database causing Restore failed exclusive access could not be obtained

I have a database A. I have taken a backup of database A called A.bak. I created a new database B. Now, I right click and Restore B from A.bak. In the Restore Dialog, I checked overwrite existing database and change the LogicalFileName from C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER2012\MSSQL\DATA\A.mdf to C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER2012\MSSQL\DATA\B.mdf and did […]

How do I find running Traces in SQL Server?

Is there an easy way to determine what traces have been set up by sp_trace_create on SQL Server 2000? How about for SQL Server 2005, 2008, 2012, or 2014?

How to restore a SQL Server 2012 database to SQL Server 2008 R2?

I am trying to restore the backup taken from a SQL Server 2012 to SQL Server 2008 R2, and it giving an error Specified cast is not valid. (SqlManagerUI) If you have any solution to this please give comment thanks.

MSSQL export database with data

How can I export my 2012 database with data to a .sql file so I can import it to a 2008 server? I’ve never been able to export the data only the structure.

SSIS Excel Connection Manager failed to Connect to the Source

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that server. The problem happens when trying to design the package. I have added an […]

Error restoring database backup

I am getting an error using SQL Server 2012 when restoring a backup made with a previous version (SQL Server 2008). I actually have several backup files of the same database (taken at different times in the past). The newest ones are restored without any problems; however, one of them gives the following error: System.Data.SqlClient.SqlError: […]

SQL Server 2012 installation Reporting Services Catalog error

I’m installing SQL Server 2012 at the moment and when I was about to run the installation, this error pops up: On clicking the first failed test, which is “Reporting Services Catalog Database File Existence”, this is what i get: On clicking the second failed test, which is “Reporting Services Catalog Temporary Database File Existence”, […]

Correct way to select from two tables in SQL Server with no common field to join on

Back in the old days, I used to write select statements like this: SELECT table1.columnA, table2.columnA FROM table1, table2 WHERE table1.columnA = ‘Some value’ However I was told that having comma separated table names in the “FROM” clause is not ANSI92 compatible. There should always be a JOIN statement. This leads to my problem…. I […]

Refresh Application Automatically When Data changed in SQL Server

I use SQL Server and I have 3 Application servers. When a table in my database have changed I need to those application servers refresh there local cached data. I use a trigger to known change and send a message via Service broker queue. Then I create a stored procedure and assign it to activate […]

How do I copy SQL Server 2012 database to localdb instance?

I’m looking to copy a SQL Server 2012 Standard database to my localdb instance. I’ve tried the wizard which complains that localdb isn’t a SQL Server 2005 or later express instance. I also did a backup/restore but upon the restore in my localdb I get the following error… Running this… RESTORE DATABASE CSODev FROM DISK […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.