Viewing 15 posts - 91 through 105 (of 155 total)
Script will result list of database(s) with no full backup:
select name from master..sysdatabases
where name not in(select distinct database_name from msdb..backupset where type='D')
March 29, 2008 at 3:54 pm
You mentioned:
At our corporate office we need failrly recent copies of the data from the offices to run reports, feed our website, etc
That means you just need to retrieve latest...
March 29, 2008 at 12:14 pm
As I understand, you changed recovery model to simple. As berry already pointed that log file will be used in any case, but you can truncate to keep it smaller...
March 29, 2008 at 12:06 pm
Pooja, please refer article http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sql2005symmetricencryption/2291/ published by Michael. That will clear all your confusion.
March 29, 2008 at 12:00 pm
please post last 10 lines of ClCfgSrv.log
March 29, 2008 at 11:44 am
You can use standard edition for Analysis Service.
March 28, 2008 at 10:12 pm
You can do it after install. set trace flag 1807 in startup parameter that will allow you to use network drive.
-T1807 should be first parameter in Startup. Make sure you...
March 28, 2008 at 9:21 pm
are you sure you specified valid account? did you follow syntax shown below to create account?:
EXEC sp_xp_cmdshell_proxy_account 'MyDomain\MyUserName', 'myDomainPassword'
March 28, 2008 at 11:55 am
March 28, 2008 at 1:05 am
Use Package configuration that will allow you pass in variables and connection information to the package at run time
March 28, 2008 at 12:05 am
can you ping server?
March 27, 2008 at 11:50 pm
Make sure that the mirror server instance has the identical jobs, logins, SQL Server Integration Service (SSIS) packages, disk partitions, file locations, and server configuration as the principal server instance....
March 27, 2008 at 10:31 pm
Viewing 15 posts - 91 through 105 (of 155 total)