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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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);...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 17, 2014 at 10:54 pm
What is the datafile and logfile size?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 17, 2014 at 10:40 pm
Easy one. Thanks Anoo.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 17, 2014 at 10:36 pm
What will be the size of the database?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 17, 2014 at 4:18 am
Check firewall settings of the remote machine.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 17, 2014 at 4:07 am
I am having around 75!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 17, 2014 at 3:58 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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 17, 2014 at 1:29 am
Bit tricky, like the questions. Thanks, Carlo.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 16, 2014 at 10:32 pm
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 14, 2014 at 6:06 am
Viewing 15 posts - 451 through 465 (of 1,179 total)