Viewing 15 posts - 6,511 through 6,525 (of 9,399 total)
laurie-789651 (2/25/2015)
Stuart Davies (2/25/2015)
SQLRNNR (2/25/2015)
Ed Wagner (2/25/2015)
BWFC (2/25/2015)
Ed Wagner (2/25/2015)
laurie-789651 (2/25/2015)
Ed Wagner (2/25/2015)
djj (2/25/2015)
Ed Wagner (2/24/2015)
SQLRNNR (2/24/2015)
fourSquare
Cube
Dimension
Declare
Decree
Absolute
Resolute
Desk
Raven (obtuse - I know)
Dun
Finish
February 25, 2015 at 9:11 am
BWFC (2/25/2015)
crookj (2/25/2015)
Ed Wagner (2/25/2015)
BWFC (2/25/2015)
Ed Wagner (2/25/2015)
laurie-789651 (2/25/2015)
Ed Wagner (2/25/2015)
djj (2/25/2015)
Ed Wagner (2/24/2015)
SQLRNNR (2/24/2015)
fourSquare
Cube
Dimension
Declare
Decree
Absolute
Resolute
Unyielding
Hard
Foundation
February 25, 2015 at 6:52 am
Eirikur Eiriksson (2/25/2015)
Quick question, what is the question?😎
Right. Without an actual question, it's difficult to give an actual answer. 😉 I don't like the cursors. Why...
February 25, 2015 at 6:51 am
It looks like you need to sum the days worked, but without an actual question, it's hard to give you an actual answer.
February 25, 2015 at 6:46 am
If you provide the database name, it has to be that of the current database.
February 25, 2015 at 6:43 am
BWFC (2/25/2015)
Ed Wagner (2/25/2015)
laurie-789651 (2/25/2015)
Ed Wagner (2/25/2015)
djj (2/25/2015)
Ed Wagner (2/24/2015)
SQLRNNR (2/24/2015)
fourSquare
Cube
Dimension
Declare
Decree
Absolute
Resolute
February 25, 2015 at 6:39 am
laurie-789651 (2/25/2015)
Ed Wagner (2/25/2015)
djj (2/25/2015)
Ed Wagner (2/24/2015)
SQLRNNR (2/24/2015)
fourSquare
Cube
Dimension
Declare
Decree
February 25, 2015 at 6:23 am
djj (2/25/2015)
Ed Wagner (2/24/2015)
SQLRNNR (2/24/2015)
fourSquare
Cube
Dimension
February 25, 2015 at 5:18 am
ramana3327 (2/24/2015)
February 24, 2015 at 1:07 pm
Is using the master.dbo.xp_delete_file stored procedure an option for you?
Edit: It's in 2012, right? I'm still on 2008. :crazy:
February 24, 2015 at 12:39 pm
laurie-789651 (2/24/2015)
Ed Wagner (2/24/2015)
crookj (2/24/2015)
djj (2/24/2015)
Ed Wagner (2/24/2015)
BWFC (2/24/2015)
djj (2/24/2015)
Ed Wagner (2/23/2015)
SQLRNNR (2/23/2015)
roofTop
Tip
Dump
Core
Apple
Mortimer (Who's your friend?)
Time
Zone
Defense
February 24, 2015 at 12:35 pm
ramana3327 (2/24/2015)
I can't able to run anything on the other server. I have the access on the backup server only. From the backup server, I have to use some...
February 24, 2015 at 12:34 pm
crookj (2/24/2015)
djj (2/24/2015)
Ed Wagner (2/24/2015)
BWFC (2/24/2015)
djj (2/24/2015)
Ed Wagner (2/23/2015)
SQLRNNR (2/23/2015)
roofTop
Tip
Dump
Core
Apple
Mortimer (Who's your friend?)
Time
February 24, 2015 at 8:44 am
This query will return the most recent full backup for the database you specify:
SELECT TOP 1 bs.database_name, bs.backup_finish_date, bmf.physical_device_name
FROM msdb.dbo.backupset bs
INNER JOIN msdb.dbo.backupmediafamily...
February 24, 2015 at 5:52 am
Viewing 15 posts - 6,511 through 6,525 (of 9,399 total)