Viewing 15 posts - 6,166 through 6,180 (of 9,253 total)
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...
January 4, 2012 at 10:09 am
sorry missed that bit, they're definitely native backups then?
How are you executing xp_delete_file?
January 4, 2012 at 9:57 am
tyang (12/23/2011)
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...
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
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...
January 4, 2012 at 9:02 am
ChrisTaylor (1/4/2012)
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
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
January 4, 2012 at 8:45 am
Glenstr (1/3/2012)
at least a transaction log backup taken before putting into simple recovery mode
The recommendation you were given was to switch to bulk logged recovery model!
Glenstr (1/3/2012)
January 4, 2012 at 8:37 am
Saggy (12/30/2011)
Hi Guys...How to migrate sql server database
for user databases, detach copy and re attcah them or back them up and restore them.
Saggy (12/30/2011)
and all system databases...
you don't! You...
December 30, 2011 at 6:11 am
avoid using the SYSUSERS table, sys.database_principals should be used instead. Incidentally, you make no provision for any certificates and their mapped users that may be in use
December 30, 2011 at 4:34 am
Sumanta Roy (12/23/2011)
I apologize that this question is not purely for SQL server DBA's but I need help understanding DSN entries provided in ODBC to connect to SQL server. I...
December 23, 2011 at 4:39 am
opc.three (12/22/2011)
Sure...but how would you copy the file (without xp_cmdshell)?
Via a VB script ran as a SQL agent job step!
December 22, 2011 at 9:20 am
personally i find this easier to create the path
exec xp_create_subdir 'G:\somepath\mynewfolder'
or
exec xp_create_subdir '\\myserver\myshare\mynewfolder'
If the folder doesn't exist it will create it 😉
December 22, 2011 at 8:36 am
Viewing 15 posts - 6,166 through 6,180 (of 9,253 total)