this data is related to antivirus servers which running from 3 yeares or more we need to delet old data because this size of data make the server so slowely.

we send SMS for people. this table contain custmers join the services and...

the data not partioned.

and i don't know how to do this. i new user for database.

i do script. but when i restore users it is not mapping to there database and the user also can't loging.

there is sign on the user indicate that it is...

i think but iam not sure that i will face problem that the user exsit in the database.

can you explain how can i do it because i am begginer in sql

thanks.

i change change memory from 60 to 100

100

and MaximumMemoryLimit from 70 to 150

150

but the error still.

can you plz tell me what exatlyi need t check in machine.config and report service.

and thanks alot

i installed SQL 2005 SP3 but i can't do mirroring and i get this error.

TITLE: Database Properties

------------------------------

One or more of the server network addresses lacks a fully qualified domain name...

thank you but how can i do it from SQL.

thanks all shrink solve the proble,:-D

i delet the data base because i need to use this space there is no enough space in the disk.