Viewing 15 posts - 1 through 15 (of 253 total)
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary...
March 15, 2017 at 11:14 pm
Windows authentication must be used when working in an Intranet type of an environment.
SQL Server authentication can be used in all the other type of cases.
March 6, 2017 at 10:26 pm
The general recommendation is that you can change an instance name if it is the default instance see here: http://msdn.microsoft.com/en-us/library/ms143799.aspx But modifying an existing named instance...
February 14, 2017 at 10:19 pm
Make sure that you can access the full pathConfirm if Data folder exists and has permissions
February 1, 2017 at 10:46 pm
Log Shipping backs up the log on the primary server and stores those backups in a local folder. > Copies those files across the network to the secondary server. > Restores...
January 29, 2017 at 10:45 pm
I found this article on google, hope it helps: http://www.sqlrecoverysoftware.net/blog/sql-error-8906.html
January 17, 2017 at 10:59 pm
i have found similar thread, hope it help: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a6dd2c4b-482f-45be-a3e8-f40af98618b9/the-mssqlserver-service-terminated-unexpectedly
January 17, 2017 at 10:33 pm
Issue could be due to hardware.
Take a look at this link: https://blog.sqlauthority.com/2016/07/22/sql-server-install-error-not-find-database-engine-startup-handle/
January 17, 2017 at 10:25 pm
I have found one SQL decryptor software[/url] on google which claims to dectypt SQL database without encryption key.
Hope it helps
January 4, 2017 at 10:35 pm
also take a look at this link: http://www.sqlservercentral.com/scripts/tempdb/72007/[/url]
December 27, 2016 at 10:00 pm
Bulk Insert can only insert and BCP can import and export.
Bulk Insert runs inside SQL Server and BCP runs outside
BCP Utility is more flexible than bulk insert - not...
December 25, 2016 at 10:50 pm
also take a look at this link, hope this will help you out: http://sqltechtips.blogspot.com/2015/11/troubleshooting-error-824.html
December 25, 2016 at 10:37 pm
If you have updated backup of you database then it is perfect time to utilize it. If the backup is not available then you try to execute the below query...
December 14, 2016 at 10:00 pm
Take a look at this link, hope this will help you out: http://www.sqlservercentral.com/articles/SQLCMD/123681/[/url]
December 14, 2016 at 9:34 pm
> Detach SQL Server database and move your MDF to save location.> Create new databse of same name, same files, same file location and same file size.> Now Stop...
December 6, 2016 at 10:31 pm