Viewing 15 posts - 91 through 105 (of 156 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')
[font="Verdana"]--www.sqlvillage.com[/size][/font]
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...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
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...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
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.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 29, 2008 at 12:00 pm
please post last 10 lines of ClCfgSrv.log
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 29, 2008 at 11:44 am
You can use standard edition for Analysis Service.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 28, 2008 at 10:12 pm
It will rollback last batch only.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 28, 2008 at 9:43 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...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 28, 2008 at 9:21 pm
yes, you should enter password while creating it.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 28, 2008 at 12:06 pm
By default, Windows domain password policy enforcement for SQL authenticated logins is enabled unless you explicitly set the CHECK_POLICY clause of the CREATE LOGIN statement to OFF when you create...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 28, 2008 at 12:02 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'
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 28, 2008 at 11:55 am
check this http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
[font="Verdana"]--www.sqlvillage.com[/size][/font]
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
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 28, 2008 at 12:05 am
can you ping server?
[font="Verdana"]--www.sqlvillage.com[/size][/font]
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....
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 27, 2008 at 10:31 pm
Viewing 15 posts - 91 through 105 (of 156 total)