Search results for query: *

Hi, Thank you for the news By the way, it is important that "your guys" informe you when they do things (ex. Upgrade, maintenance, etc) that can affect your work. A + Calico

Hi I will try to check for you on what object(s) you can set a profiler trace. I don"t know if it possible. Calico

Hi, 186 + 47 = 233 gigs is a very big database How database is refreshed every night ? - Backup/Restore ? - Replication ? - Other method ? At what time the job starts in the night and how long does it take to the job to complete ? - 2 hours ? - 12 hours ? It look like the job is...

Hi, This is not a very large database if the .BAK is not zipped. <<copy and restore a database backup from SF to NY>> Does it mean that you want to copy and restore a database backup from San Francisco to New-York ? Is yes, you can ZIP de .BAK file and attache it to an "email" and send it...

HI, Q: Is a master-->target configuration what i need? A: may be it is what you need calico

hi, How BIG is your backup file ? is it a .BAK file ? Calico

Hi, How big is you DB ? How long does it take to the job to complete ? May be the job is not "completed" early in the morning ? May be some problem with your store-proc (ex: "execution plan", "procedure cache", etc) Did you check if your DB are corrupted (both DB) ? May be problem with your...

Hi, On google tried loking on those words: RAISE ERROR Event Viewer SQL Alert I am not suree if I understand your need and what you mean by SQL's notification tool Calico

HI, With SQL 2000, we have similar problem. application not dropping idle SQL connections as it should OR debugging tool still activated on production Calico

Hi, Those files (Agent log and Agent.out) are outside of any database and those files must be backup with other toll like NT backup, backup-exec, etc... Only the transaction-log of a database can be backuped by "BACKUP LOG" sql statement. Calico

Hi, You can use the "Scripting Wizard" for SP, VIEW and UDF to script all those objects into a file and after edit (scan) this file to look for the given table name . (on MSSM, righ click on the DB / tasks / Generate script) You must use PROFILE to dentify had-hoc query. Identify the...

Hi, Thank for the link: http://msdn.microsoft.com/en-us/library/ms345408.aspx Those 3 blocs are very important to my understand, but I never experimeted those steps 1 ------------------------------------------------------- Planned Relocation and Scheduled Disk Maintenance Procedure To...

Hi, Hummm. Merge replication ! I am not familar with merge replication I think it is normal that you also have 10 triggers that did not exist in the backed up database. I think those triggers are created by the replication process. For the "missing 62 of them", check in the old server if...

Hi, Big job ! HINT 1 : With sql 2005 : with Profiler and Database Tuning Advisor. Check carefully new indexes suggested by the Database Tuning Advisor. IF an index is suggested for a table, may be it is because a table scan exist on this table. Try to identify SP or view ou had-hoc query...

Hi, I think you cannot move or rename the Resource database file Here some hint i founded into th book online -------------------------------------------------- In SQL Server 2005, you can move system and user-defined database files, except the Resource database files...

Hi, Did you execute "DBCC Checkdb" before the backup and after the restore to be sure that the BD is not corrupted ?

Hi, SQL server 2000 Full recovery mode Backup log every hour This is a theorical question Suppose I detach/attach a BD, and 2 days after, I want to retore the database from 1 week ago and applied all trx-log backup until today. Because I detach/attach DB 2 days ago, is the LSN still in...

Hi, Suppose this scenario: WSS and SPS 2007 are installed. One morning the Sharepoint Config database is "SUSPECT". If a SQL SERVER backup exist (.bak), is it possible for the DBA to SQL RESTORE from config.bak ? Does the Sharepoint Admin need to execute some others tasks after the SQL...

Hi, When I use Join ({?@parameter},",") "default values" fields are used How can I use the Join () where "description values" are used thank you Calico

Hi, With CR is it possible to create a reports that use as input many queries and tables like we can do in MS ACCESS ? In others words, it it possible to create a query2 that use (as data source) query1 and tables that are related togather ? If not, what is the alternatives ? Stored proc...