Activity overview
Latest activity by aultmike
Peter,
Thanks for the reply! I DIDNT know about that feature in the RESTORE command but I will look into it! [image] My intent isnt to do a full restore every morning but rather do a full restore and then apply log backups indefinately. / comments
Peter,
Thanks for the reply! I DIDNT know about that feature in the RESTORE command but I will look into it! My intent isnt to do a full restore every morning but rather do a full restore and then...
Concurrent backups (full and transaction)
My intent is to test my recovery model and setup log shipping to replicate a database on another server.
I have a database called AdventureWorks on a primary sql server. Presently SQL Backup perfor...
Network Copy Location keeps trying to copy to the old path
We were using the Network Copy Location feature to copy backed up databases and transaction logs from our sql server to a NAS. The NAS died the other day and I changed the Folder in which I wanted ...
AWESOME Thanks! / comments
AWESOME Thanks!
It doesnt seem like I can use multiple file location tags when specifiying a path. Am I doing something wrong?
Here is what I specified:
P:\MMurphy Test\<DATETIME yyyy>\<DATETIME mm>\<DATETIME dd>\DataHubPomereneHere is what I got:
P:\MMurphy Test\2013\<DATETIME mm>\<DATETIME dd>\DataHubPomereneI got an error when it tried to backup the database to the path above. / comments
It doesnt seem like I can use multiple file location tags when specifiying a path. Am I doing something wrong?
Here is what I specified:
P:\MMurphy Test\<DATETIME yyyy>\<DATETIME mm>\<DATETIME dd>\...
I'm still digesting most of your post but I did want to mention that the use of the 'Test" button under the Copy to network section doesnt work when you use the file location tags. The process still works but that can be confusing. / comments
I'm still digesting most of your post but I did want to mention that the use of the 'Test" button under the Copy to network section doesnt work when you use the file location tags. The process stil...
Outcome column on Jobs tab is misleading
I'm confused. After I manually start a backup job a few minutes later the Outcome column reports successful but if I look in the Inprogress tab the backup job is still Running...isnt that misleading?
Is the copying of backups to a network location separate?
When the "Copy Backups To Network Location" option is used, Is it run on a thread separate from the actual backup process?
It seems to me that it would be preferred that copying the backups would h...
Use of file location tags in "Copy backup to network locatio
Can I use the file location tags in the "Copy Backup To Network Location" option? Originally I would like to organize my backups by year-month-day. I have a finite amount of local storage and organ...