Hi Lowell, I got results with your first script.

But when I run the 2nd, replacing Steve's name with my name, I get no results (and no errors).

I'm not familiar enough...

• This reply was modified 4 years, 3 months ago by homebrew01.

What happened to Gail Shaw ?

She used to be a regular poster on SSC.

Create a job, which copies the backup file to the destination server. Then script out the restore process, and put that as the next job step.

After the restore, you may...

When looking at backups at a company, I found a "full" backup was running every hour during the day, according to the MSDB tables. Digging a bit more, it seems...

• This reply was modified 4 years, 3 months ago by homebrew01.
• This reply was modified 4 years, 3 months ago by homebrew01.
• This reply was modified 4 years, 3 months ago by homebrew01.

Great Script !!

I added user type 'K' , because I found I have that type of user, also needing to be included.

• This reply was modified 4 years, 3 months ago by homebrew01.

NET GROUP Error: This command can be used only on a Windows Domain Controller.

The user does display in other groups.

If I run :

EXEC xp_logininfo 'MyDomain\ShopOrderEntry', 'members'

I do get a result...

• This reply was modified 4 years, 3 months ago by homebrew01.

Thanks !  xp_logininfo will work for me.

In Management Studio, in your database, Click on "TABLES", then in Object Explorer Details, you should see a list of all your tables. You can select them all, then right...

• This reply was modified 4 years, 3 months ago by homebrew01.

What size is your log file ?   xyz.LDF

I just added up a database's MDF, NDF and LDF and everything matched up. when comparing sp_helpdb and the windows file info.

• This reply was modified 4 years, 4 months ago by homebrew01.
• This reply was modified 4 years, 4 months ago by homebrew01.

I used CozyRoc at my last job and was satisfied with it. I think there was a similar product, for a bit less $, but don't remember the name.

It was my second day, not my first, but the boss told me, "OK, put it into production."  Wait, what?  I was used to creating release packages, not doing...

I have been away from SQL for a bit...getting rusty !

• This reply was modified 4 years, 5 months ago by homebrew01.

Is that new ?

So a Domain Admin can't grant SQL Admin access to another Windows Admin account, if the Domain Admin has not specifically been given SQL Admin permission at...

Make sure you have regular backups of all user & system databases, especially before doing any type of server or software changes.

No need to get political or contentious. Jeff was raising valid concerns, based on the (lack of) information provided.

• This reply was modified 4 years, 6 months ago by homebrew01.