Viewing 15 posts - 931 through 945 (of 1,179 total)
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 12, 2009 at 6:48 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2009 at 4:59 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2009 at 4:51 am
Hello Raj,
You can save the report to shared folder. After that with Database mail send the report as an attachment.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2009 at 12:46 am
create SSIS package to do the same which is having more functionality.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2009 at 12:43 am
set sql server Agent service startup type to Automatic.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2009 at 12:40 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 5, 2009 at 6:30 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 5, 2009 at 6:23 am
Refer following link for further detail:
http://support.microsoft.com/kb/321185
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 27, 2009 at 3:13 am
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2009 at 6:34 am
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?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2009 at 5:01 am
Refer the following link for the O/S requirement.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2009 at 4:56 am
You can develop the script for the same.
or
Search on the web(google) you will find one. 😛
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2009 at 4:38 am
Also depend on no. of Backup devices 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2009 at 4:35 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2009 at 4:31 am
Viewing 15 posts - 931 through 945 (of 1,179 total)