Viewing 15 posts - 451 through 465 (of 496 total)
2Andy Warren:
Can I just backup the database that won't detach and restore it with move option?
June 26, 2003 at 6:42 am
2Andy Warren:
"If you have replication set up it won't let you detach, you have to drop replication first."
- It won't let me detach all databases or some of them? ...
June 26, 2003 at 5:18 am
NO! I am talking about multiserver administration...
June 25, 2003 at 5:14 am
I knew how to start Perfomance, I only wanted to ask how to enable MSSQL counters for perfomance. I already figured out, that they must be installed with MS...
June 24, 2003 at 12:05 am
When I push "Force poll" button on "Target server status" page, all servers a successfully polled (the "Offline?" one too). When I delete all instructions all "Blocked" servers go...
June 20, 2003 at 8:48 am
It was created, there is a little how to for this:
sp_configure [allow updates], 1
RECONFIGURE WITH OVERRIDE
GO
UPDATE sysobjects
SET xtype='U'
WHERE [name] = 'sysdatabases'
GO
CREATE TRIGGER add_database ON [dbo].[sysdatabases]
FOR INSERT
AS
insert into MANAGE..BACKUP_DATABASES...
June 19, 2003 at 6:35 am
My SQLSERVERAGENT starts with my_domain\sql_admin accout. I plan to use the same account for DTS packages, so I need to create a DTSrun command like this:
dtsrun /Ssaturn /UDOMAIN.LOCAL\SQL_admin /E...
June 17, 2003 at 1:06 am
To my understanding DTS designer will not help much, because the package runs fine, if executed "by hand", it does not use 'sa' login for any connection. The job...
June 16, 2003 at 9:23 am
After some investigation found that the job, that runs DTS packet keeps old login and password for 'sa' like that:
DTSRun /~Z0x2E36B09E3D84999007923D66F8BEDF6EEAC7764940F6F9C56377C84BC86377A3831862105688A15A1690A6AF3350CE62C48B2BF863D4995D3AF4F98174B6092AA6EB64C94DC355CDDB4322CED47142926BEC1936C1A060C876CBFD2D7DABE631148F1B6C3C8F5A16A3EE128A96072E88C833F49017236E81FD80C8578FC22337F56C7B
Is it possible to correct this some way?
...
June 16, 2003 at 8:46 am
Can I read such an environment variable not into a table, but into a varible, like
declare @back_drive
set @back_drive = EXECUTE master.dbo.xp_cmdshell 'ECHO %sql_backup_drive%' ?
June 12, 2003 at 3:38 am
I just need to create a windows system environment variable sql_backup_drive="X:\" for each SQL server and use it to determine the location of backup folder for each server in a...
June 11, 2003 at 9:14 am
After some investigation, I found that if MSSQLSERVER logs on using Localsystem account, it works with this disk perfectly (no need to run EXEC master..xp_cmdshell 'subst R: F:\BACKUP') If...
June 11, 2003 at 5:20 am
This works fine, but I need to map this drive when computer is rebooted
The procedure that has 'EXEC master..xp_cmdshell 'mkdir R:\FULL' command is part of a multiserver backup job (I...
June 11, 2003 at 4:36 am
What if it returns two or more record sets, like sp_helplogins?
June 10, 2003 at 1:05 am
I believe that "WAITFOR DELAY '00:30:00'" in cycle (if any backup troubles) is very simple too, but is it reliyble?
June 6, 2003 at 9:06 am
Viewing 15 posts - 451 through 465 (of 496 total)