Viewing 15 posts - 5,401 through 5,415 (of 9,241 total)
You do not need to manually manage the log shipping backup files, they are managed by the log shipping system stored procedures and the agent jobs.
Personally i would recommend that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 28, 2012 at 6:22 am
Yes 2008 you have to edit the tcpip bindings in the registry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 2:25 pm
Steve Jones - SSC Editor (6/27/2012)
Enjoy. Save some $$ for tickets 😉
Surely you mean £££ 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 12:52 pm
Source and destination db, etc are a collection of items under the database details property
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 11:20 am
Vertigo44 (6/27/2012)
should I place DTC on one of the SQL Group Volumes?
If you do this you'll need to put the DTC resources in the same cluster group as the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 9:52 am
SQLRNNR (6/27/2012)
The image won't come up for me.
it should open in a new window, alternatively the car is pictured here 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 9:48 am
*yawn*
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 9:13 am
hi thanks for your comments, hope you found it useful
Regards Pez
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 8:21 am
to be clear this details the types
catalog views
compatibility views
dynamic management views (which also includes functions)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 8:19 am
what does the following registry branch show
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 4:55 am
for info, sys.master_files is a catalog view not a DMV
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 4:01 am
the declaration you have made for@Data1 is only relevant to the internal part of the procedure. You are attempting to pass a parameter @Data1 from outside the procedure and would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 3:43 am
DPM takes backups in a completely different fashion to Redgate SQLBackup. SQLBackup will most likely, if standard config, be generating .SQB files and these are the SQL Server backups.
As Jeffrey...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 3:25 am
the message gives you all the info you need. The task is not an editable SSIS object, rather, it has a set of properties that define the execution context. Right...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 3:19 am
go into sql server configuration manager and check the alias section. Someone has setup an alias for the named instance probably
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2012 at 3:10 am
Viewing 15 posts - 5,401 through 5,415 (of 9,241 total)