Are you able to see that in sql server surface area configuration??

Try giving port no in sql server configuration manager..

Think you have a nice and efficient maintenance plan on your mind.Go ahead.All the best.:D

I want to send a proposal to client who want to make a test environment which is an exact replica of production environment.His requirement is "how to buid a user...

Created a job for the maintenance plan and alert is made to email id but am not getting any alert.I have given the option after completion of maintenance plan the...

Many Thanks jsheldon

Thanks Dude its worked liked anything

😀

Can you please explain a bit more on that.

The machine to which i have to take backup is not in the same domain nor it have any domain.When i connect to that machine from the RUN am able...

you cannot connect remotly using alias name.you can connect to server using instance name .

I Think for your purpose you have to dettach the database and copy paste the log file to other array. In that case database will be offline.You can also try...

You maps a login or a user to a particular database only after creating the user.

you cant restore the last two transaction log backups taken after B2.

Go to registry -->software-->mssqlserver--> instance there you can find the server name.If you are using SQL Server Express edition then give the instance_name\sqlexpress.

Hope the issues will arise when the database size becomes very huge.