Could you please try by regedit.

That is right file name can't have /\:*?"<>|.

Thanks MANU for modifying the code to take a backup 🙂

Hi Vivien Xing,

I am also feeling so happy because the...

Please make sure the maintenance plan or job does not have additional T-SQL script which is doing some thing with the table 'msdb.dbo.log_shipping_databases'.

or

Create a new maint plan with...

RP_DBA given you perfect solution for your problem.

Hi,

You can find which user dropped tables and sp's from your database by using database log reader tool.

Hi, here is the link to download...

Hi,

I have written stored procedure 'create_DBFolders ' for you. This will do your work. Just create the sp and schedule this sp by creating new job.

CREATE PROCEDURE create_DBFolders

AS

BEGIN

--Declare...

I do not think you can decrease the backup time by changing the recovery model.

You can increase the backup time by using third party backup tools like SQL Litesppend,...

really I did not understand what is your problem.

You can see the ERRORLOG file from the errorlog path usually will be

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

open the ERRORLOG file with notepad.

It is good sing that sql server using required memory until unless there is a performance issue or there is no memory for another application.

If you want to find...

may be you do not have test database in your server.

use your database name in place of test.

or execute the below statement

CREATE DATABASE test

Are you new to SQL Server.

Please execute the below script step by step and let me know where the scrip is getting fail.

--Step 1: Create database masterkey for Test

USE Test

CREATE MASTER KEY ENCRYPTION BY PASSWORD...