Viewing 15 posts - 451 through 465 (of 1,179 total)
After the restart the server your script run successfully to do the mapping. But when SQL Server runs the backup it won't able to access the path as SQL do...
March 17, 2014 at 11:59 pm
Update and Delete both required exclusive lock hence it is natural. To avoid you can BCP data to archieve/delete during offpeack hours.
HTH
March 17, 2014 at 11:42 pm
The possible reason could be you might have restoed the database without move option on secondary database. If you do not specify move option while restore it will restore the...
March 17, 2014 at 11:36 pm
check this out from BOL:
-- Ensure a USE <databasename> statement has been executed first.
SET NOCOUNT ON;
DECLARE @objectid int;
DECLARE @indexid int;
DECLARE @partitioncount bigint;
DECLARE @schemaname nvarchar(130);
DECLARE @objectname nvarchar(130);
DECLARE @indexname nvarchar(130);...
March 17, 2014 at 10:59 pm
All 5 fingures are not equal. The same way all developers are not equal and their skills vary based on interest, knowledge and experience. As all human are unique could...
March 17, 2014 at 10:54 pm
What is the datafile and logfile size?
March 17, 2014 at 10:40 pm
What will be the size of the database?
March 17, 2014 at 5:39 am
Execute sp_clean_db_free_space to clean gost record and again check.
If your server is production be careful running this. Also advisable to take full backup before executing this command. Prefer to execute...
March 17, 2014 at 4:18 am
Check firewall settings of the remote machine.
March 17, 2014 at 4:07 am
Is this production server?
First of all check the history of Snapshot Agent.
If snapshot agent failed collect the information why it failed from history and log.
Also check the schedule...
March 17, 2014 at 3:53 am
It all depend on your environment. You can do Reindexing but advisable to have low activity on the server. You can have reorg + reindexing of highly fregmented indexes. Least...
March 17, 2014 at 1:29 am
Do not club concept of Logshipping with Mirroring. Refer the following MS link for better understanding:
http://technet.microsoft.com/en-us/library/ms189852.aspx
HTH
March 14, 2014 at 6:06 am
Viewing 15 posts - 451 through 465 (of 1,179 total)