Hello,

Refer following link for more detail:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_0evalplan/html/62021d0b-1b8d-4276-b373-a01184006d42.htm

You do have two things:

Enable AWE OPTION

or allocate fixed 4 GB to sql server

HTH

First check out of 110 GB howmuch is occupied and howmuch is free? If considerable free space you can shrink file.

Other possibility if mirrored is not happening properly on the...

That means there are no error messages. 🙂

You need not worry and eventhough you haven't ran DBCC CHECKDB for last 14 months doesn't mean that there may be any...

Hello Raj,

You can save the report to shared folder. After that with Database mail send the report as an attachment.

HTH

create SSIS package to do the same which is having more functionality.

HTH

set sql server Agent service startup type to Automatic.

Hello,

Your question is confusing.

model.bak is used to restore the model database. If you don't found model.bak in backup folder does not means that you lost the database.

If the system backup...

Provide more info:

There are many options Like:

1. Shrink file

2. move .mdf or .ldf files

3. Purge data

4. delete unwanted files from the drive.

5. delete old back file if not required.

Might be...

Refer following link for further detail:

http://support.microsoft.com/kb/321185

Chekc following link might useful:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/c963e8b4-5a85-4bd0-9d48-3f8da8f6516b.htm

see the following comand too:

SET DATEFORMAT { format | @format_var }

HTH

Looks like permission problem or the file is used by some other process:

Are you able to access the location 'E:\MSSQL.5\MSSQL\JOBS\' from the other server?

Refer the following link for the O/S requirement.

http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/RequirementsSQL2005.htm

HTH

You can develop the script for the same.

or

Search on the web(google) you will find one. 😛

Also depend on no. of Backup devices 🙂

Hello Ritesh,

Your question is to set the default collation "Latin1_General_CI_AS".

First Uninstall the sql server and reinstall it:

Whiel reinstalling in the collation settings select following options:

Select Radio button "Collation designator and...