What was in the 'company backup'?

you say you reinstalled windows. did you reinstall SQL server?

Don't want to get too technical but if you have an MSSQL.1 and .2 and .3...

select name from sys.databases where state_desc = 'offline'

or you can use databasepropertyex or even databaseproperty (pre 2005)

Skills for database backup and more importantly recovery are with the DBAs so they should control database backup tools and strategies.

I think you will find 99% of DBAs use SQL...

good to learn of this new syntax change, should have specified SQL 2008 though.

This one is very basic and simple but seems a complete no-brainer to me:

the ability to specify who the owner of the jobs will be when creating\amending maintenance plans.

Then you...

whats wrong with etc in a server or database name?

😀

nice one Dave, good job.

there is some inconsistency in the names of the backups and locations I think you may want to check and edit 😉

Great job Dave, well done.

The automation of the process and use of proxies is a nice touch.

There is nowhere near enough information on SSRS DR out there and this is...

going to have to refer you to my previous answer, there is no other possible cause of this.

State 11 means 'Valid login but server access failure'

check in AD that the group and user are allowed to access the server.

I have only seen that WMI message after a server rename and the local SQL accounts were orphaned,

e.g. server\SQLServer2005MSSQLUser$server$MSSQLSERVER

check those accounts out for file permissions (their sids will appear but...

we need the STATE value from that error message.

Are you a member of this windows group?

mpalaparthi (4/19/2010)

---

Hello,

U r correct, thats the prefered method, but in that method we have to take tail log backup so I am just wondering if it interupts the...

why not use the full backup from the weekend, the last diff backup before 12:45, and whatever log backups you need to get to 12:45, using the stopat clause with...

did you use configuration manager to change the account SQL runs under. Doing it that way should assign all the permissions necessary.