Viewing 15 posts - 6,166 through 6,180 (of 9,244 total)
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
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2011 at 8:36 am
Dhirju (12/22/2011)
how to restore master database?
Ensure you restore the model and MSDB too.
Do you have any experience of starting\operating SQL Server in single user mode?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2011 at 8:03 am
slipstream is used at product install not post product install. You will have to apply the service pack as usual.
For future reference see my article at this link[/url] detailing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2011 at 8:00 am
daveFromIll (12/21/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 21, 2011 at 4:17 pm
mahesh.dasoni (12/17/2011)
But in MSDB database(Primary server)-the table log_shipping_monitor_primary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 21, 2011 at 4:01 pm
To stop services remotely open the services.msc on your machine. In the top left of the services console where you see "Services (local)", right click and select "connect to another...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 21, 2011 at 3:54 pm
pallavi.unde (12/16/2011)
USE master
GO
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL
DROP PROCEDURE sp_hexadecimal
GO
CREATE PROCEDURE sp_hexadecimal
@binvalue varbinary(256),
@hexvalue varchar (514) OUTPUT
AS
DECLARE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 21, 2011 at 3:49 pm
Viewing 15 posts - 6,166 through 6,180 (of 9,244 total)