Viewing 15 posts - 6,151 through 6,165 (of 9,241 total)
Are you running this ad hoc or are you going to schedule it?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2012 at 1:36 am
Jeffrey Williams 3188 (1/4/2012)
Perry Whittle (1/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 3:15 pm
jspatz (1/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 2:50 pm
if you're executing this within a sql server agent job i'd use a VB script
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 10:36 am
I use a simple VB script which works quite well at trimming backup files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 10:32 am
doesnt seem to much wrong with the syntax, remember that as an undocumented extended proc this is liable to change with any release.
I'm using SQL Server 2008 R2 SP1...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 10:25 am
Ray K (1/4/2012)
Steve Jones - SSC Editor (1/4/2012)
When you rebuilt, and resinstalled, I assume, did you "add Current User" as an administrator? That's easy to miss.
Yeah, that I did remember...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 10:09 am
sorry missed that bit, they're definitely native backups then?
How are you executing xp_delete_file?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 9:57 am
tyang (12/23/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 9:49 am
Tara-1044200 (1/4/2012)
Can someone help me with the sql to schdule restart of sql service and aagent service and also send mesage 15 min before to the users logged in?
You...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 9:42 am
I've had issues in previous times backing up SharePoint databases. Qualifying the database names with QUOTENAME() has always resolved the issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 9:40 am
ananda.murugesan (1/4/2012)
Right now server is ready with operating system - windows 2008 32 bit, Disk configuration etc..
currently server is work-group, N/W has been configured and server is not member of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 9:02 am
ChrisTaylor (1/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 8:52 am
what happens if you run
RESTORE HEADERONLY FROM DISK = N'm:\MSSQL\MYBAKFILE.BAK'
obviously substituting your drive path and filename details
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 8:47 am
forsqlserver (1/4/2012)
My mistake..Compress backup is enable.Its fine..
For future reference the following tools can help to provide info about a sql server backup file
RESTORE FILELISTONLY
RESTORE HEADERONLY
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2012 at 8:45 am
Viewing 15 posts - 6,151 through 6,165 (of 9,241 total)