Viewing 15 posts - 76 through 90 (of 253 total)
•Verify that at least one secondary replica is configured as automatic failover. If there is not a secondary replica configured as automatic failover, update the configuration of a secondary replica...
May 6, 2016 at 11:16 pm
sometimes this error occurs because connection was closed by the database server but the connection remained valid in the connection pool of app.
Reset the application pool to get app back...
May 6, 2016 at 10:59 pm
Take a look at this link: https://msdn.microsoft.com/en-us/library/ms187348.aspx
May 6, 2016 at 12:07 am
Delete the device by using the following command to allow SQL Server to perform new backups to the backup device
BACKUP DATABASE mydatabase TO DISK='C:\MyDatabase.bak' with FORMAT
If the error message occurs...
May 4, 2016 at 11:32 pm
1.Right-click on Database -> select 'Tasks' -> select 'Generate Scripts'
2.Select database objects. Click Next
3.Click Advanced and scroll down to 'Types of Data to script' and choose 'Schema and Data'. Click...
May 3, 2016 at 10:19 pm
These links might be helpful for you:
http://www.sqlservercentral.com/Forums/Topic980739-1549-1.aspx
May 1, 2016 at 11:20 pm
Execute below query
USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @oem_errorlog=0
GO
April 28, 2016 at 11:12 pm
Take a look at this article hope this will help you out: http://www.sqlserverlogexplorer.com/fix-error-message-40/[/url]
April 28, 2016 at 11:04 pm
Take a look at this link: http://www.sqlservercentral.com/Forums/Topic1664960-2799-1.aspx
April 19, 2016 at 10:25 pm
You can also take the help of this link: http://sqlbak.com/blog/automated-database-backup-and-restore-for-sql-server/
April 18, 2016 at 11:19 pm
Remove SQL server from add remove program
•Delete the entire Microsoft SQL Server folder from the registry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
•Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\ and search for components related to default...
April 18, 2016 at 10:49 pm
To disable distribution using SQL Server Management Studio
1.Connect to the Distributor you want to disable in Microsoft SQL Server Management Studio, and then expand the server node.
2.Right-click the Replication folder,...
April 18, 2016 at 10:32 pm
Database migration:
Moving a database from one server to another.
Database Refresh:
Overwrite the existing data in the database with other database data using backup files.
April 17, 2016 at 10:58 pm
You could try running a unlodctr/lodctr on sqlctr.ini to see if that helps. Another suggestion: http://www.sqlservercentral.com/Forums/Topic424661-146-1.aspx
April 17, 2016 at 10:42 pm
Shipping Tool can take screenshots of an open window, rectangular area, a free-form area, or the entire screen.
SnippingTool.exe is located in the System32 folder but it can also be...
April 13, 2016 at 10:50 pm
Viewing 15 posts - 76 through 90 (of 253 total)