this is not OS related problem, Verify that the specified path has sufficient disk space for the file, also make sure specified path has required permissions in place for SQL...

Thanks Grant for updating..

as mentioned by Grant, parameter sniffing does make you query slow. I personally experienced it.

go through below article.

http://blogs.technet.com/b/mdegre/archive/2012/03/19/what-is-parameter-sniffing.aspx

try to add user to profile as below

EXEC msdb.dbo.sysmail_add_principalprofile_sp

@profile_name = 'Profile_Name'

, @principal_name = 'Login_Name'

, @is_default = 1;

DECLARE @sql varchar(max)

SET @sql = 'Update '+ @baseTable +' set Quantity = s.Quantity

from ' + @baseTable +' p , '+ @stageTbl +' s

where...

you can refer Paul's below article.

http://www.sqlskills.com/blogs/paul/sql-server-2008-does-my-database-contain-enterprise-only-features/

yes

refer below articles..

https://www.simple-talk.com/sql/backup-and-recovery/partial-backup-and-restore/

http://www.mssqltips.com/sqlservertutorial/27/sql-server-partial-backups/

basically from your secondary server you should be able to access backup folder, try to login to your secondary server with SQL Service account user name and password and then...

give SQL service account full access to this folder

make sure your SQL service account has the rights to access network path.

go through below article to get an idea about SQL backups.

http://www.mssqltips.com/sqlservertutorial/6/types-of-sql-server-backups/

seems to be complex, but you can try this..

SELECT pv.NAME , min(ID) id, Candy , Chocolate from (

SELECT Name , Candy , Chocolate from

...

try this

EXEC master.dbo.sp_addlinkedsrvlogin

@rmtsrvname = N'<REMOTE_SERVER>',

@locallogin = N'AppLogin',

@useself = N'False',

@rmtuser = N'Basic_Login',

@rmtpassword = N'<Basic_Login_Password>'

i don't think it is possible to identify RAID config in windows unless you have installed vendor software on it