Alen
  • Member for 5 years
  • Last seen more than a month ago
Symantec Backup Exec runing DBCC CheckDB and Backup on my SQL server
3 votes

I'm not sure if Symantec still owns it, but Backup Exec is Netbackup's little brother. I don't remember the feature differences but Netbackup is more for Enterprise environments and Backup exec for ...

View answer
What are pros and cons of Ola’s scripts vs using maintenance plan?
3 votes

I'm not 100% sure of his scripts but custom scripts are way better than maintenance plans. The built in plans will rebuild every index on a table no matter how little fragmentation. If you have Always ...

View answer
Differential Backups with Replication?
2 votes

I used to manage an environment where we had transactional replication and the backup schedule was Weekly Full, Daily Diff and log backups several times per day. The backups didn't have any effect on ...

View answer
What is better? Many articles in one publication or many publications with one article each one?
Accepted answer
2 votes

My last position we had dozens of publications. We would group the articles by size where the largest tables with millions or tens of millions of rows would have their own publication and others would ...

View answer
How to relate Agencies at the State, County, and Local Government levels
1 votes

Is there anything wrong with having one table for agencies and a column for the agency name and three columns for governments. State, county and locality. Assuming this is a national database, the ...

View answer
Storing personal data on an invoice to preserve data integrity
1 votes

I used to work in an organization with this problem and this is how we solved it. We had one database with the customer and service info. It had address fields that changed any time a customer ...

View answer
how to avoid insertion of the two entries in database by two users which are working in same application with same database?
1 votes

You need to create a primary key or a unique index on the column. The application should have code to pass the error from the SQL server that a primary key violation would occur if the record is ...

View answer
Can a MS SQL Server be named different than host computer?
1 votes

If you have access to DNS, you can create a CNAME record to point to your SQL server and name the CNAME anything you want. If you don't have access to DNS, then you can ask the IT people to do this.

View answer
Why shouldn't user-defined database roles be members of fixed roles?
1 votes

My guess would be say you have a role to assign users to a subset of tables and/or procedures in a database. If you add that role to say the datareader role then they would have access to every table. ...

View answer
Migrating SQL Server 2000 to 2008/14 - Stored procedures compatibility?
1 votes

This is something that needs to be tested since many commands have been deprecated between 2000 and 2014. Assuming you are moving the database to another server I would test this first. Restore the ...

View answer
Any system tables/views to determine query volume per table
Accepted answer
1 votes

You can use statistics data by tracking the most modified ones SELECT --into ##SQL_STATS_INFO --comment out h. columns for non-sql 2016 servers distinct (select db_name()) as ...

View answer
Making Production database as Publisher and Distributor for Snasphot Replication
Accepted answer
1 votes

It depends on your hardware. I've seen a table in the 70GB range take approximately 20 minutes to create a snapshot. Longer on older hardware. If anything else is being done, it can result in blocking....

View answer
Batch Requests/sec reported by DMV millions of times larger than Activity Monitor
1 votes

I may have found part of this from stackoverflow, but I like to use select sqlserver_start_time from sys.dm_os_sys_info for this. A lot of the data in sys.dm_os_performance_counters is ...

View answer
Benchmarking procedures or Upgrade tests to be done after upgrading to SQL Server 2016 from SQL Server 2012
1 votes

When I did SQL 2005 to 2012 I used the Distributed Replay Controller feature. You run a profiler trace with the DRC template. Then run the command on a few servers and it runs those trace files ...

View answer
Is Database Backup Time = Restore Time in SQL Server?
1 votes

10GB is fairly small. I've backed up and restored databases into the hundreds of gigabytes and I've seen big differences in backup speeds among different databases on the same server and between ...

View answer
Automate the patching of SQL Severs on Windows
1 votes

Have you looked at WSUS for windows updates? For SQL service packs we usually run them manually after scheduling downtime

View answer
Use Netbackup 7.7 `WITH KEEP_CDC`
1 votes

https://www.veritas.com/support/en_US.html you'll have to find the SQL Agent Guide for that version of Netbackup and see what it supports. Technically you need 7.5 to backup SQL 2012 but I think that ...

View answer
Huge database - challenges
1 votes

YOu can start by running the MS SQL Profiler tool to see which tables are used by the applications that use the server

View answer
Automatically Execute Stored Procedure After Any RESTORE DATABASE Event
0 votes

How are you running your backups? With Commvault you can set up an automated restore job and have it run pre and post restore scripts which can be SQL or powershell. I do this all the time to run DDL ...

View answer
Suggestion on Missing Index Creation
0 votes

I've created indexes from recommendations of the missing index DMV's on SQL 2005, 2012 and 2016 and have had mixed results. Sometimes the same recommendations kept on popping even though the exact ...

View answer
Database Maintenance Job and Backup Scheduling
0 votes

In addition to the above you can schedule so that your log backups don't run during the index maintenance and reschedule your full to run after the maintenance job. You will need to set up a backup ...

View answer
Will a VM backup of a SQL Server work for restoring the SQL database
0 votes

It will work, but you should only use it as a last minute backup before an upgrade to a newer version of SQL or something similar in case you need to rollback the OS and application versions. For SQL ...

View answer
SQL Server Redirect
Accepted answer
0 votes

What about a SSRS server with a connection to the remote SQL server. Not the same as yours, but I've managed a SQL server where I imported data from a remote Postgres server two firewalls away. The ...

View answer
Error 18456, Severity 14, State 8
0 votes

My first question to myself would be, does the IP in the error correspond to a known SQL server or application server IP address? Or a known IP of a DBA's personal computer? If not then it probably ...

View answer
Backup cut-off time for Full, Differential, Log, File, Partial backups
0 votes

If I had to guess then i'd say when a differential backup starts it identifies the changed pages at that point and backups those extents. Anything else is most likely not backed up. My reasoning is ...

View answer
Frequency of SQL DB Full and Differential backups
0 votes

If you have a third party backup product in your organization, check it out. We do nightly full backups for a few TB of databases with several months of retention time. Commvault is able to compress ...

View answer
Clustered Primary Key that is never used vs. Non-Clustered Primary Key on Multiple Columns
0 votes

I'm working on a similar problem right now except more columns and millions of rows. We have a PK that isn't used in any queries. We ran a preliminary test where we changed it to a non-clustered PK ...

View answer
SQL Server 2016 Availability Group - 2 Nodes as Primary & Readable Secondary, 1 Node as DR
0 votes

I've done something similar to this. I set up two AlwaysOn clusters with each one having two nodes in the primary data center with a common secondary at a DR location. I don't remember all the ...

View answer
Splitting the servers
0 votes

If you do AlwaysOn with readable secondaries you don't have to backup and restore every night, SQL Server will send all transactions to the secondary as they are executed. You will also need to make ...

View answer
SQL Server distributor server move
0 votes

If you have VmWare or Hyper-V and assuming your current distributor is a physical server you can move it to a virtual server. I believe VMWare's utility is called p2V and MS should have something ...

View answer