how to backup read only database - social.msdn.microsoft.com
Jan 22, 2016 · You cannot backup secondary database in Logshipping by TSQL/native backup mechanism but there are other ways to take file system backup. You take backup of SAM on which …
Must declare scalar variable "@DatabaseName"
Oct 22, 2016 · You are probabl on a case-sensitive SQL Server and the script has a bug in it since it apparently wasn't tested on such a SQL Server. Make sure that the case (upper/lower) matches …
Shrinking the log file and fragmentation
Feb 14, 2014 · DBCC SHRINKFILE ( Database_log_file_name , NOTRUNCATE) This statement don't break log shipping. But, you may need to run more than one. For each run, the log shipping backup, …
SQLWriter - social.msdn.microsoft.com
Apr 6, 2010 · Sqllib error: Database zDBA of SQL server instance LK6 is stored on multiple volumes, only some of which are being shadowed.
How to Migrate and upgrade a 2005 SSRS instance to 2012?
Jul 8, 2014 · In Reporting Services, we can upgrade a SQL Server 2005 Reporting Services native mode deployment to a new SQL Server 2012 Reporting Services instance. First we should back up …
Best practice to install SQL Server - social.msdn.microsoft.com
Aug 15, 2018 · So I wanted to know how many data drives will be needed to install the SQL, and what is the best practice to install.
Migrating a TFS project collection to another server
Nov 6, 2014 · -Run SQL backup of project collection db. -Restore project collection db in stage. -Add TFS service account to restored db.
Sql database server (Create another user other than SA Account)
Apr 2, 2013 · Refer link : Connect to SQL Server When System Administrators Are Locked Out. YOu can unloack sa account or can give permission to other user as sysadmin if no user having sysadmin …
Installing Software on Azure VMRole - social.msdn.microsoft.com
Nov 15, 2010 · In addition to what Fernando pointed out, please make sure the software is lisenced. To workaround the potential disk lost issue when your instance is moved to another node, you can take …
Corruption in sys.sysobjvalues - social.msdn.microsoft.com
May 5, 2010 · DBCC CHECKTABLE shows 8 consistency errors in table 'sys.sysobjvalues' in our database (SQL Server 2005, SP2). REPAIR_REBUILD option could not fix the problems.