Tag Info

New answers tagged

0

You could shut down the mirror SQL Server instance using SQL Server Configuration Manager, make a copy of the database files themselves, restart the instance, and attach the files using a different database name via the FOR ATTACH or FOR ATTACH_REBUILD_LOG options. CREATE DATABASE TestAttach ON (FILENAME = 'C:\somedata.mdf') LOG ON (FILENAME = ...


0

You might try something like the following, replacing the db and table names ... into desired_copy_db_name..tablename(col1, col2, ...) select col1, col2, ... from live_mirror_db_name..tablename This would be after the structure of the copy_db had been created.


0

I agree this should be moved to the dba stack exchange, though since I answer there as well I will post it here should it be migrated. The only way to access a mirrored database from the mirror server is through a database snapshot, which will require enterprise edition of SQL Server. It will also be READ ONLY, so this may not work for what you want. The ...


0

I used the database tuning advisor to recommend several statistics, and after applying those in test environment with a restored backup of the database in question, performance was significantly better. Dont just blindly accept what the DTA suggest. Instead it should be thoroguhly analyzed before jumping on a conclusion. Would it be a potential ...


1

Would it be a potential bottle neck on performance if a statistic had already been created automatically for the same column(s) by SQL Sever and my script creates a duplicate statistic? Surely you can write your script such that it detects such a duplicate statistic, instead of just blindly creating another one (possibly multiple times)? We do this for ...


3

Don't know that you're going to get anything much simpler than this: DECLARE @x TABLE(a VARBINARY(64)); INSERT @x(a) SELECT 0x480069002100 UNION ALL SELECT CONVERT(VARBINARY(64),(REPLICATE(N'x',32))); SELECT CONVERT(NVARCHAR(32), a) FROM @x FOR XML PATH('tag'); Results: <tag>Hi!</tag> ...


2

When you right click on Tasks and use the Import Data/Export Data task, you're building an SSIS package in the background. In the penultimate screen, you're usually greeted with Instead of Run immediately, check "Save SSIS Package". I generally save to the File System with the Package Protection Level of Do not save sensitive data. Your preference may be ...


0

The easiest solution would be to install a new instance of SQL Server (preferably one newer than 2005 RTM, which isn't supported anymore). If you have recent and valid backups: restore your databases on the new instance. If you don't have recent and valid backups: copy over the other MDF/LDF files, attach them, cross your fingers and say 30 hail marys ...


2

Error message says mssqlsystemresource is not found.,you can try copying resource database mdf and ldf to its place from another sql server instance. Source version from which you will copy resource database mdf and ldf should be same as destination version Below link may help you in knowing how to check resource database version and location of resource ...


0

First: synchronize 1 table from Azure to Sql Server. Second: Execute some Store procedures in the SQL Server 2005 instance. And third: Synchronize various tables from Sql Server to Azure sequentially. You can use the Azure data sync, but its buggy - since I never managed to get it running flawlessly for even a week. It is still in Preview mode with ...



Top 50 recent answers are included