Reputation
10,954
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
2 26 65
Newest
 Revival
Impact
~815k people reached

6h
awarded  Revival
19h
comment Manual sync between 2 SQL server databases
And? Have you looked into any of those options because they all are available to you.
1d
revised show invalid object name
added 130 characters in body
1d
answered How do I generate the ENCRYPTED_VALUE for CREATE COLUMN ENCRYPTION KEY?
1d
answered Powershell invoke sqlcmd
1d
revised Powershell invoke sqlcmd
edited tags
Apr
30
revised Completion of SQL Job triggers start of job on a different SQL Server
Added note on job step config
Apr
30
answered Completion of SQL Job triggers start of job on a different SQL Server
Apr
26
comment Keeping (Partial) Backups Small when using SQL Server FILESTREAM
Have you looked at the piecemeal restores? This is supported with SIMPLE recovery.
Apr
26
comment Accessing file share from ETL package in SQL Always-On configuration
Considered using DFS?
Apr
26
comment Backup and restore specific filegroups
What you are asking is not possible. Your only option is to export the data needed and import it into your desired destination.
Apr
26
revised Backup and restore specific filegroups
format
Apr
25
revised Most efficient way of finding rows in a table that don't exist in another — SQL Server
added 7 characters in body; edited tags
Apr
25
comment Problem inserting into table from trace file consumes all space in tempdb
What database is the DBTRACE being created in? Use DBCC OPENTRAN() or sys.dm_tran_database_transactions to see what is using tempdb.
Apr
24
comment How is powershell commonly used in SQL server?
As well if you are referring to MS putting more into SQLPS the community is assisting in this via a Trello site..
Apr
24
comment How is powershell commonly used in SQL server?
Not that this is a bad answer but you only pointed out probably 0.5% of what I use PS for with SQL Server. Also the site you noted, viewing a handful of that author's script is just executing T-SQL via a PS script and didn't see one utilizing SMO which is more common.
Apr
22
revised SQL Login curretly in use or not
corrected running to disabled
Apr
22
answered SQL Login curretly in use or not
Apr
20
answered Windows Authentication fails with “Cannot generate SSPI context”
Apr
18
answered Can mirroring be used to upgrade SSRS?