Viewing 15 posts - 91 through 105 (of 154 total)
Go to Your Local publisher Folder
then select your publisher choose properties then choose Subscription Options Check schema replication is true if not make it true.
This will replicate schema changes...
June 18, 2009 at 1:07 pm
Users can fetch reports from server B
June 18, 2009 at 11:07 am
WinCC is designed for visualizing and operating processes, production flows, machines and plants. With its powerful process interfaces (to the SIMATIC range in particular) and secure data archiving, WinCC provides...
June 18, 2009 at 11:02 am
Make sure you have full permissions on Tape More over its a error from database make sure you close all connections using activity monitor or sp_who/sp_who2
🙂
June 17, 2009 at 1:37 pm
Transaction log bakup will have extn of .trn .
If you want to take in the same file backups
backup database to disk='path'
Dont mention with init so that it will...
June 17, 2009 at 1:08 pm
Plan for any backup tool like veritas or red gate if not we need to use \\path create a folder and share it to s1 . Give full permissions .
June 16, 2009 at 1:00 pm
Go to sql surface area configurations then switch to service select automaticaly from start mode. click apply and ok.
May 28, 2009 at 9:44 am
There might be a problems if you trying to run Diff and Log at the same time. Make difference of 15 Min diff.
Three different jobs is fine for that.
Correct or...
May 27, 2009 at 3:00 pm
Use RDP (remote Desktop) connect to all servers but make sure you copied sql server 2005 both server and client tools or what ever you require which is necessary for...
May 27, 2009 at 2:51 pm
Statistics will be updated automatically after index rebuild
May 27, 2009 at 2:48 pm
use the following
Backup log with truncate_only
dbcc SHRINKFILE(DBNAME,0,Truncateonly)
May 27, 2009 at 9:45 am
Well you can drop the database if its for testing purpose.
To Restore:-
Restore Database with recovery
May 27, 2009 at 9:38 am
If a database is detached while in the recovering or standby state, it cannot be reattached .
May 27, 2009 at 9:36 am
Viewing 15 posts - 91 through 105 (of 154 total)