Hi,

You cant configure log shipping between SQL 2000 to a SQL 2005 server, becuase you can't restore log backup from SQL2000 to SQL 2005 server.

Refer the below link, this may help you.

http://www.sql-articles.com/articles/diffdbmrr.htm

Hi,

This error will occur when the mail size is too large. Consider in this case if the statement "Select * From MIS.dbo.MIS_Log" returns a large number of rows then automatically...

Hi,

Check the below steps and make sure you haven't missed any step.

1.) Dbcc traceon(1807) is not effective until you restart sqlservices, so you need to add the above trace in...

Hi,

Pls check the file SQLAgent.Out located @ Log folder at the time of sqlagent service startup failure (i.e after reboot)

Try changing the startup service account via SQL server configuratin manager.

Are...

Hi,

Can you be more clear? Why you are going for SKUPGRADE? If your question is to install "SQL Management studio", then start installation in GUI select client components only @...

Hi,

Pls check RW privilege for SQL service startup account on both the files(i.e in file level also, goto file property and check) and also the folder where the files are...

Make sure the 3rd instance startup account has necessary privileges in all the drives.

Refer the below link, this may help you

http://forums.microsoft.com/MSDN/showpost.aspx?postid=2363979&siteid=1

Hi,

Provide necessary privilege for SQL service startup account to the network path "\\WXPPRO-xxx98\C_Drive\SPAImport.txt" and then try Bulk Insert.

Hi,

It is not an issue, but its a best practice to keep the db owner to the respective users, because if a user is dbo then he can do all...

Refer the below link, Steve has provided all the version list

http://www.sqlservercentral.com/articles/Administration/2960/[/url]

You cant apply Tlog backup when the db is in online.

1.) Restore the last full backup with norecovery

2.) Restore Tlog backup with recovery and specify the point-in-time.

Refer the below link

How...

Hi,

Which physical file has freespace??

If its .mdf (datafile) then

DBCC shrinkfile('Logical MDF filename',3250)--Where the value should be greater than 3GB

If its .ldf (log file) then the below command

1.) Backup log dbname...

You said after applying SP2 the service account for Database engine changes to local system. Have you tried once againg chaning it to Local account?? IF yes what is the...