In additiona to what Lowell has shown, there is a parameter available that defines the database to be used for the query: @query_database (I think - look it up to...

Another option is:

PS> Get-ChildItem $path -Recurse | % {$_.GetAccessControl()}

Or, you can use an expression:

PS> Get-ChildItem $path -Recurse | Format-Table FullName, @{Label="Owner";Expression={$_.GetAccessControl().Owner}}

For the owner:

PS> $path = 'T:\MSSQL'

PS> Get-ChildItem $path -Recurse | % {(Get-Acl $_)} | Format-Table

By default, that will get you the Path, Owner and Access. Not sure about...

Because then you don't have control over the sequencing of the backups. However, you could create separate maintenance plans...

If you are looking to speed up the transfer of the compressed file, then your options are limited. If you can get away from FTP, you could use a...

Backing up across the network is much more open to failure. If there are any issues with the network, your backups will fail. Additionally, there are configuration settings...

You really shouldn't use a percentage for auto-growth, on either the data or log files. You don't really want that to ever happen, but if it does - you...

Apparently, you can use this on a full backup also. This can be used when migrating a database to a new server.

Perform the full backup with norecovery - at...

Read the article in my signature on Managing Transaction Logs. You cannot move data in the log files the way you are trying to, you have to perform transaction...

Shawn, yes - I didn't see that. Thanks.

The recommended method is now:

1) Alter Database {db} Modify File (Name = logical_name, filename = 'new pathame');

2) Alter Database {db} Set Offline With rollback immediate;

3) Copy files to new location

4)...

First, you need to identify how a user is associated to a particular group. Looking at the data, there is no way to tell that User2 belongs to Group1....

Ken Klaft-381933 (10/6/2010)

---

While it doesn't matter a lot, I typically append my tlog backups to the full backup file to make a nice tidy package for portability. (The full...

Okay, I want to make sure I am understanding here.

Did you use SSMS to create the maintenance plan?

Did you use the maintenance plan schedule to schedule and create the agent...

Okay - how was the agent job created? Did you create the agent job manually, or did you setup the schedule in the maintenance plan and set it up...