RAID 1+0 is the best other option that i forgot to say anyways thanks for george for having rminded for that.

I can't think of anything without using cursors. You will havt to use them anyhow.

http://mssqltips.com/tip.asp?tip1086 this link might help. But check if you are following it up right.

Check what is the last restored file in the secondary server. Then copy all files from the primary server to the destination file and start the restore job so that...

Do a checkpoint in your database so that all the uncommited transaction commit then you will have enough space to truncate and allocate to OS.

use DBCC sqlperf(logspace) to see how much your log file is used.

then use backup log dbname with truncate_only

then dbcc shrinkfile(logfilename,targetsize)

where traget size should be more than the size being used...

Accepted from query analyzer if you don't specify the path the path of the model database is taken for creating the database.

First start with comparing the data between the two databases. You can use tools like SQLDelta, Quest Data Compare or Red Gate Data Compare. Then decide on which data to...

Change the job to run under the agetn service account instead of sa account and see if that succeeds

Hey buddy your job is running under localsyste, account which has access to local resources only and not network resources. NT AUTHOURITY\SYSTEM corresponds to LOCALSYSTEM account use a domain account...

As mark says you can move to a server locally if you have additional hardware resources else better stick off with disk and tape combination.

Again tried and getting what microsoft should fire server does not exist. The right message.

http://vyaskn.tripod.com/code.htm#inserts

http://www.codeproject.com/dotnet/ScriptDatabase.asp

Hope these script/link will be useful for you.

If those that that exist in both the database have the same bnumber of column and the same columns then you can merge the data instead of having it in...

Does the database being used for Transactional purpose and is there large number of updates/deletes/insert happening every second. If so then there is a possibility as SQL server reads backup...