Viewing 15 posts - 46 through 60 (of 65 total)
SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
Around the time you found this in your logs ..... you...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 3:29 pm
sinhaashish2001 (8/25/2009)
We can do it in SQL Server 2005 and 2008 using Initializing a Transactional Subscription with a backup.
I am not sure what you meant there ....
did you mean...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 3:24 pm
whats the SQL Server version ? 2000 or 2005, 32 bit or 64 bit ?
as a general guideline with the given amount of memory i would leave SQL to manage...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 3:00 pm
Executing the query "BACKUP DATABASE [master] TO DISK = N'\\\\NASServerSQL\\data\\production\\ServerName\\master_backup_200908251120.bak'
notsure ... might be very basic .... but do these double \\ sound right ... shouldn't it be a...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 2:53 pm
http://www.replicationanswers.com/Articles.asp is good resource .... where you might find an answer to your situation ... some cool tricks there .....
I dont think you are left with much choice right now...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 2:44 pm
first line of the script should be
USE [ your database name ]
HTML tags messed it up :pinch:
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 2:16 pm
yes login mappings seems to be the culprit .... you could run the below script to fix any orphaned SQL logins that you might have on the SQL 2005 box.
USE...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 2:15 pm
also check for any blocking in the system when your job is running.... you mentioned that there is no other job running when you are running your job, but there...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 2:04 pm
if you have devlopers login as a sql login as opposed to windows one .... you could also map the logins
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 2:01 pm
restoring msdb database might work in getting the distribution agent back ... but I am not sure if it would solve your problem or replication thinking that I am all...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 12:56 pm
pls give details of the process used to move tempdb files .... that would be helpful in giving a solution. Also - is this SQL 2000 or 2005 or 2008...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 9:41 am
depends on what kind of replication you want to set up.... but anyways if you are thinking of doing a transactional replication (which is the most common), then the answer...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 25, 2009 at 9:35 am
any idea how to check that for sql 2005 ??
sysjobsteps table has details of an ssis package (which is created for the maint plans). is there a config file...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
October 21, 2008 at 12:25 pm
not required
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
November 2, 2006 at 9:24 am
I agree with the above post .... the best insider info available is in the book Inside SQL Server 2000. but then it only talks about overview of the process,...
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 20, 2006 at 2:23 am
Viewing 15 posts - 46 through 60 (of 65 total)