Data Recovery Reports > SQL Server 2005: Automating Database Movement

[Pythian Group Blog] One way would be to write stored procedures and call them with a batch file using osql.exe and SQL Agent job or your enterprise scheduler. There’s nothing wrong with that approach, but I think that for this task, SSIS packages give more options, flexibility, and simplicity for ongoing management.

Previous [Previous] SQL SERVER - Remove Duplicate Entry from Comma Delimited St...

Next [Next] ZianBIT - Laptop Recovery » Blog Archive » Data Re...

Some related posts from Technorati and Google.

[0DayCar] 0DayCar: FME Desktop 2009.5658: Tightly integrated with FME Workbench, the FME Universal Viewer lets you quickly inspect your spatial data's geometry and attributes - before, after, and even during the transformation process. You can use it to examine features, identify attributes and values, and enhance the display using color, symbols and labelling.

[SQL Server Performance] Best Practices on Disk Defragmentation methods on a SQL Server ...: But to address this issue you cannot perform a downtime to SQL Server services in order to let the operating system defragmentation tool too defrag the physical file, and theoritically speaking there isn't much external fragmentation anyway. It's more helpful to regularly reindex your data to reduce the internal fragmentation as much as possible, that will reduce the outer layer of fragmentation of physicial file where the effectiveness of the read-aheads and the amount of data that can be buffered, to the maximum (as per my tests).

[big files freeware, shareware, demo, software downloads, downloadable, downloading] Nc import downloads - Abetone-Datenbank download - Database ...: SQL Server, Interbase, MySQL, and PostgreSQL. Typically Visual Importer Professional is used to download files from an .

[MSSQLTips - Latest SQL Server Tips] Junior SQL Server DBA Interview Questions: The questions in this tip are intended for a newbie SQL Server DBA, but more often than not, you will get some very challenging questions and scenarios from interviewers. Many of these situations and questions will probably not be familiar to you, so think quickly and be sure to prepare a response to questions you simple do not know the answer to.

[SQL Server Blog by Jason Massie] Tagged: New Year’s Resolutions > SQL Server Blog by Jason Massie ...: Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. He has worked at Terremark (formerly Data Return) for nearly a decade.

[MSSQLTips - Latest SQL Server Tips] An alternative to SQL Server email alerts: Most of these jobs are usually maintenance type jobs or data loads, but this tool can be used to run any T-SQL code or even execute programs external to SQL Server. If you have jobs that run on a frequent basis or if you have a lot of jobs that are scheduled you may notice that there is not much historical information stored when you view job history, so what can be done to keep more historical run information?">Missing SQL Server Agent History

[SQL Home rss feed] Monitor your Database Backups Using Operations Manager: So, I went about trying to piece together some T-SQL that would return three columns: database name, number of says since the last full backup, and number of days since the last differential backup. I could change the code to include transaction log backups, if desired, but my goal for this example was simply to check that nightly differential backups, and a weekly full backup were being done.

[Reseller News] Reseller News > Deep dive into SQL Server 2008: Because most versions of SQL Server can handle unlimited data size, enterprise edition is generally chosen for the features. As a result, you're likely to have plenty of SQL Server boxes in your shop with very large data sets that aren't on enterprise, and they need compressed backups too, which means you probably already have a third-party backup solution in place.

[Pythian Group Blog] How to Minimize Downtime When Moving to a New SQL Server Environment: Modify the job schedule of the replication Log Reader job to start automatically when SQL Server Agent starts (this will set it up to continuously replicate transactions) and start it manually (you need to do this once because SQL Server Agent is already running).

[SQL Home rss feed] Brad's Sure DBA Checklist: are reused from execution to execution of the same stored procedure is to ensure that any user connections information, SET options, database options, or SQL Server configuration options don't change from execution to execution of the same stored procedure. If they do change, then SQL Server may consider the same stored procedures to be different, and not be able to reuse the current query plan stored in cache.

[uCertify's learning platform] MCITP 70-444 Short Notes: Exam passing Tips: Server Browser service is a tool used to connect to an SQL Server instance if a DBA is not able to connect to that instance through DAC. It can be configured either during the installation of SQL Server or by using the Surface Area Configuration Manager tool.

[Journey to SQL Authority with Pinal Dave] SQL SERVER - 2005 - Create Script to Copy Database Schema and All ...: I am new to database sql server 2005.I want to change the data type of a column in the table. Therefore i created a new column with the required data type and tried copying the contents of the main column to the new column.But the problem is, the table is around 4gb and therefore when i try to execute the above said procedure my transaction log gets filled up really fast.I have around 25gb of free space in the drive.The transaction exceeds the available space and i get an error.I tried executing the transaction in the simple recovery model and also full.but both ways the transaction log filled up really quickly and exceeded the available space.

Reflected tags on Technorati: Blog, ,