Forum Replies Created

Viewing 15 posts - 46 through 60 (of 71 total)

  • RE: Page Allocation

    I think your question is pointed to "if pages are allocated or data can be inserted when the backup is running.", if this is true, the answer is YES.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 3:10 pm

    #1085050

  • RE: backup with filegroups and partitions ramifications

    Please review these SQL Server Book Online topics

    SQL Server 7.0 Books Online topics:

    "Physical Database Files and Filegroups"

    "Using Files and Filegroups"

    "Creating Filegroups"

    "Creating File or Filegroup Backups"

    "Using File or Filegroup Backups"

    "Restoring...

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 3:04 pm

    #1085048

  • RE: SQL Express Code Help

    Review this thread

    http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/5924074f-5f1c-444a-bd09-fc3e999f2637/

    It has a interesting code there.

    Regards

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 3:01 pm

    #1085046

  • RE: point in time recovery

    Here is a tutorial about it

    http://www.mssqltips.com/tutorial.asp?tutorial=119

    Regards

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 2:54 pm

    #1085044

  • RE: How to get Batch file error Message

    Are you using xp_cmdshell to execute your BAT file?

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 2:44 pm

    #1085042

  • RE: backup

    Here is good tutorial about backups.

    http://www.exforsys.com/tutorials/sql-server-2005/sql-server-database-backup.html

    Regards

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 2:42 pm

    #1085040

  • RE: Generating SQL Logins\users and permissions for a database

    You can use SMO Object Model to implement backup script, database restore and restore scripting.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 10:05 am

    #1084975

  • RE: Generating SQL Logins\users and permissions for a database

    Hi

    Review this article, it contains your requirements.

    http://www.sqlservercentral.com/scripts/Security/66129/

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 9:59 am

    #1084974

  • RE: Trigger to add user to db_owner role after db restore

    You ca use Service Broker Technology to capture the Event and raise an action

    Review this article and modify it according your requirement.

    http://www.sqlteam.com/article/centralized-asynchronous-auditing-with-service-broker.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 9:55 am

    #1084973

  • RE: Permission Table for many users

    Use views to restrict the scope and Stored procedures to add data.

    Regards

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 9:44 am

    #1084967

  • RE: Regarding xp_sendmail

    Hi

    Please read this article to expand the topic.

    http://www.zimbio.com/SQL/articles/1204/Database+Mail+vs+SQL+Mail+SQL+Server+2005

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 9:37 am

    #1084962

  • RE: calculate Avg.Disk Queue length

    You can read this article to capture IO Stats

    http://www.mssqltips.com/tip.asp?tip=1416

    Regards

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 27, 2009 at 9:32 am

    #1084958

  • RE: SQL Monitoring Tool needed ASAP

    Hi

    Please evaluate @nalytics Performance Free Data Collector for Microsoft SQL Server &

    Windows Server, this tool can help you to solve your performance problems and get

    performance archive history information...

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 26, 2009 at 9:37 pm

    #1084774

  • RE: Long running query - out of ideas

    Hi

    You can use @nalytics Performance Free Data Collector for Microsoft SQL Server &

    Windows Server to see what waits the instance is doing , this tool can help you to...

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 26, 2009 at 9:36 pm

    #1084773

  • RE: High % Disk Time but low Avg. Disk Queue Length

    Hi

    Please evaluate @nalytics Performance Free Data Collector for Microsoft SQL Server &

    Windows Server, this tool can help you to solve your performance problems and get

    performance archive history information...

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

    November 26, 2009 at 9:34 pm

    #1084772

Viewing 15 posts - 46 through 60 (of 71 total)