Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 96105

All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.

4
votes
4answers
I have three SQL database instances on a cloud server: A, B and C and the Server Installed Physical memory (RAM) is 32GB. The size of A (data+log file) is 44GB and B (data+log file) is 41GB. We ignore …
asked May 8 '17 by Raidenlee
0
votes
2answers
Currently we have 3 AD users that can log into a Windows Server: MRT\administrator MRT\adminJohn MRT\adminAlice They all logged into the Windows Server 2012 and then does the following: MRT\admi …
asked Nov 16 '16 by Raidenlee
-1
votes
Enabling this will allow you to communicate with the SQL Server via any medium internally (VPN network) and externally. Some practical uses are: Third Party SQL server reporting application like: h …
answered Aug 15 '16 by Raidenlee
4
votes
3answers
I want to select an alias based on specific column criteria and output the required XML. Say we have a table named ACCOUNTS: Name Age --------- --- John Doe 30 Mary Lane 40 Alice Bob 50 …
asked Jun 30 '17 by Raidenlee
0
votes
I can't comment under the question but i can tell you what i did. I had a similar issue like that due to a break in the restore chain. I tried manually editing the monitor tables to "hack" the replayi …
answered Aug 15 '16 by Raidenlee
1
vote
Try querying without the "top 100": SELECT * FROM msdb.dbo.backupset WHERE name = "abc" OR SELECT bs.database_name, bs.backup_start_date, bmf.physical_device_name, …
answered Sep 7 '16 by Raidenlee
1
vote
The main step is initialization. You can take a full and/or differential backup of the Production, restore at the DR using that backup and then setup log shipping with no problems at all. You must kee …
answered Aug 12 '16 by Raidenlee
0
votes
First execute: ALTER TABLE TestTable DROP CONSTRAINT DF__Test_Table___datec__0D7A0286 Then execute: Alter Table TestTable Alter Column datecreate datetime
answered Dec 11 '16 by Raidenlee
0
votes
If i understand correctly, you want to reinitialize log shipping from B to A? If yes, then once you bring the DR site database (B) online you automatically break the LSN chain hence the restore log f …
answered Dec 11 '16 by Raidenlee