Kincly check whether your database mail services has been enable. chekc the settings in Surface Area configuration - features

Hi,

I dont know how to implement your suggestion.

i have to have a cell in a table like this , kindly suggest the steps.

RESTORE DATABASE [b]DBNAME[/b] FROM DISK = N'File Source' WITH FILE = 1, MOVE N'MDF Name' TO N'MDF PATH', MOVE N'log Name' TO N'Log Path', NOUNLOAD, REPLACE, STATS = 10

Kindly fill...

Hi,

Are you looking for this query

RESTORE DATABASE [DBNAME] FROM DISK = N'File Source' WITH FILE = 1, MOVE N'MDF Name' TO N'MDF PATH', MOVE N'log Name'...

Hi,

check what is given in auto growth if it is restricted then it will grow only till the size specified, if is auto grown given in percentage or mb then...

Joc activity monitor will giev you all jobs with last run date and future run date , will you need more.

Any error on database mail log?

check the setting again whether something got changed.

The data you are entering into asset table doesnt have the reference data of product id available in product table.

always check whether reference data is available in primary table(product) using...

Kindly give more information like front end application, slowness in single page(query) or more, try finding out using profiler in sql stmt completed or SP stmt completed which is taking...

hi,

yes still want to recover it because while trying inserting more than a year data may miss out that too from different sources.

i want to update my knowledge as a...

hi,

They dont have a manual file backup or db backup. the client doenst have a well known IT person also.

can i know is it possible now with these situation.

currently they...

No log backup taken. No truncation also done.

Friends customer is non technical guy so hope nothing is done other than deletion of MDF file when server is down.

They have copied...

Hi,

They have restored and found the recovery model as Full recovery.

sorry for not understanding it properly.

Thanks

Hi,

yes it is a full backup

Hi,

Kindly explain me individual steps so that i can help them.

sorry for not undetanding it from your post.

They are taking backup by right click in the database default i hope...